'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.
- 10.7K All Categories
- 13 Getting Started in the Community
- 31 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 301 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board