'OR' condition possible with ETL Join function?
To report on video engagement by project, I need to join Workfront project field data set with a Brightcove data set. There are 15 video ID fields in the Workfront data set and one video ID field in the Brightcove data set.
If the Brightcove video ID field value matches one of the fifteen video ID field values from Workfront, I want an inner join to create a new data set.
The Join works if only one field comparison is set up at a time though. Is it possible to configure Join is some, but not all conditions are met? If not, suggestions on another approach would be most welcome.
Thanks!
Best Answer
-
Hi Catherine,
While I don't fully understand what your desired outcome is, I think there are a couple options.
- Create 15 joins in the ETL
- One for each id in the Workfront dataset.
- Collape columns
- You could collapse all 15 id columns into 1 column. The rest of the data will be duplicated onto every line. You could then make one inner join on the new single id column.
I hope that helps!
Thanks,
Tyler Lamparter
Manager, Business Analytics and Transportation
Titan Distributors, Inc.
1 - Create 15 joins in the ETL
Answers
-
Hi Catherine,
While I don't fully understand what your desired outcome is, I think there are a couple options.
- Create 15 joins in the ETL
- One for each id in the Workfront dataset.
- Collape columns
- You could collapse all 15 id columns into 1 column. The rest of the data will be duplicated onto every line. You could then make one inner join on the new single id column.
I hope that helps!
Thanks,
Tyler Lamparter
Manager, Business Analytics and Transportation
Titan Distributors, Inc.
1 - Create 15 joins in the ETL
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive