Keep Columns After Using Group By Tile in ETL
I haven't played around with the group by tile yet so this might be a very simple answer I overlooked. But why do all of my columns disappear and leave only the columns I identified in the group by tile from my data after I use this function? I know I could join the data back in but I was assuming I was using it wrong. This is my etl -
Best Answers
-
Because they have now been aggregated and Domo doesn't know how to aggregate the remaining columns. So if you include them in the group by then they aggregate as much as they can with those fields, example:
- You have dates and a category included in the group by and individual transactions summed. Domo will aggregate (sum) to the highest level of unique combination of date and category. As you add more fields, it changes the grouping. Examples illustrating this below:
Raw Data:Group by 1: Date
Category can't be added here because both categories exist for both dates, so to group by date means excluding category.
Group by 2: date and CategoryIf I solved your problem, please select "yes" above
0 -
Depending on your groupings and the metrics you're calculating you can either group by and then join it back to your original dataset like you mentioned or possibly use a Rank and Window tile to do your aggregation within your entire dataset and leave your columns in place. But @ColemenWilson mentioned, aggregation drops it because it doesn't know what to do with all your other columns.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Because they have now been aggregated and Domo doesn't know how to aggregate the remaining columns. So if you include them in the group by then they aggregate as much as they can with those fields, example:
- You have dates and a category included in the group by and individual transactions summed. Domo will aggregate (sum) to the highest level of unique combination of date and category. As you add more fields, it changes the grouping. Examples illustrating this below:
Raw Data:Group by 1: Date
Category can't be added here because both categories exist for both dates, so to group by date means excluding category.
Group by 2: date and CategoryIf I solved your problem, please select "yes" above
0 -
Depending on your groupings and the metrics you're calculating you can either group by and then join it back to your original dataset like you mentioned or possibly use a Rank and Window tile to do your aggregation within your entire dataset and leave your columns in place. But @ColemenWilson mentioned, aggregation drops it because it doesn't know what to do with all your other columns.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@deona720 - Feedback on the Dataflow - Is there a reason you are using so many append tiles? I strongly recommend appending all of them in one append tile. This will not only be more efficient, but will allow you to easily review them all at once for any field conflicts.
Additional recommendation - Name each of those formula tiles so that you can tell which is which in your append.
DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0
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
- 737 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