Can my output include projects that don't have a column value for a Split / Group
Hi all,
I have this ETL which takes a multi selection attribute (Div) with 19 values and does the following:
- Splits each selection option into its own column
- Converts the columns to rows
- Filters to remove instances where there was no delimiter, because if only 1 of the 19 values was selected - these showed up as "Not Defined" on a second row
- Groups the 19 selection options into just 5
- Adds the formula CONCAT(`
ProjectName`
,`Div Grouping`
) to identify unique combinations of Name and Div - Adds in other relevant columns
- Removes the duplicates based on the CONCAT
It is working as intended where Div is set. However, is it possible to somehow still include projects that don't have this attribute set? I mentioned above in step 3, that it somewhat erroneously showed a Not Defined when it could not find the delimiter because only 1 value was selected, but I'd really want it to show Not Defined when no selection options are made.
Any solution to this? Hand holding greatly appreciated; this is only my 2nd day of using ETL, so still lots to learn! 😀
Best Answer
-
If that is the case, you could add a path to your ETL that filters to only rows with null values for Div and then append those to the rest of your data.
If I solved your problem, please select "yes" above
1
Answers
-
Hey PJG,
Could you provide an example input and desired output?
Thanks,
1 -
Hi nmizzel - thanks for the quick reply.
Here's a very simple example of the input and the desired output
The issue is that I cannot see Project4 in the Output, but I suspect it's being removed at the Split action, since it has no Div values set.
Thanks
1 -
If that is the case, you could add a path to your ETL that filters to only rows with null values for Div and then append those to the rest of your data.
If I solved your problem, please select "yes" above
1 -
Thank you for pointing me in the right direction, Colemen. Got it working with this:
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive