Combining two header rows
I am receiving data in the format below. I would like to merge the two header rows into one where it would merge 'Date and Product Qty'.
What does it look like in Domo after you use the file upload?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
It is an emailed dataset. Since first few headers are blank in the first header row, DOMO is renaming it as C1, C2.... and reading the rest of the lines as data (please see attached)0
I don't think there's an easy way per-se to accomplish this.
1) create a rownumber called row_id using the Rank & Window Tile.
2) split your data using 2x SELECT tiles, with Row_ID in both SELECTS. such that SELECT 1 contains all the 'other metrics' and SELECT 2 contains the months of 'projected quanitty.'
3) in SELECT 2, filter out the rows where the value = "projected quantity", then convert the data type to numeric. At this point you should have a ton of columns called 'dates' of data type number.
4) use Dynamic Pivot to collapse your data into a column containing Label "Dates", and values are the actual quantity.
5) add a constant "Metric" = "Projected Quantity.
6) JOIN SELECT 1 and reshaped SELECT 2 on the Row_ID.
collapse projected quantity using 'dynamic pivot.' such that you pivotJae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Thanks, I was able to achieve what I was looking for by using 'Dynamic Pivot' function of the magic ETL. Thanks again for your help!0
You should also be able to do this using the file connector. Just click on edit selection and have the header include both rows:
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Thanks. I receive this data every week. If I use data connector upload file, I will have to do it manually every week. I was looking for something that can automate this whole process, which I was able to do by using the unpivot function. Thanks to all of you for your quick replies!0
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 82 Cards, Dashboards, Stories
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 176 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive