Question on Expanding Data to Display Unique Values
Is there a way to take the data that has a start/stop year (Column A/B) and have it expand while retaining the associated notes from Column C? The data is in Domo, but can manipulate in excel. The goal is to convert columns A-C to E-F. Not sure which platform makes most sense to make this happen (excel, access, Domo).
Best Answer
-
You can do this within a Magic ETL.
If you do something like this:
This will do a cartesian join between the list of years and your dataset and then filter the records where the year is in between your original start and end years. Add formula is adding a new column called Join Column with a value of 1 for the join.
I've attached a JSON file with the definition (minus the input and output datasets) so you can copy the contents and then control+v/command+v/paste them into your Magic ETL canvas.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
You can do this within a Magic ETL.
If you do something like this:
This will do a cartesian join between the list of years and your dataset and then filter the records where the year is in between your original start and end years. Add formula is adding a new column called Join Column with a value of 1 for the join.
I've attached a JSON file with the definition (minus the input and output datasets) so you can copy the contents and then control+v/command+v/paste them into your Magic ETL canvas.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Thank you Grant for the response. I will be working on this.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive