Question of how to mark or pass data for certain amount of records
Best Answer
-
Hi @mhouk
I built a Magic ETL that will get you pretty close to what you are looking for
1st on your data add a column and name it "ROW" that states the row number in your data.
2nd open a magic etl and copy/paste the code attached
3rd connect your input and name your output
4th run it and review the results
your output should look like this (the highlighted columns are your original fields in the spreadsheet)
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1
Answers
-
Hi @mhouk
I built a Magic ETL that will get you pretty close to what you are looking for
1st on your data add a column and name it "ROW" that states the row number in your data.
2nd open a magic etl and copy/paste the code attached
3rd connect your input and name your output
4th run it and review the results
your output should look like this (the highlighted columns are your original fields in the spreadsheet)
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1 -
First off thank you for responding! This is a crafty why i would have not thought up.
So I was able to input it with some small issues but I'm able to get output but it's not working the same way. The activities are not properly mapping to the choices.
I am wondering if I did the Join's Wrong or if when it branches with the filters…
I also want to mention that it looks like your output is correct but also not what im looking to fully achive. In this test case each record in between the activity represents a person. So each building unit is a record and will have data along with these three columns.
The Excel file i uploaded now shows what I would like my end goal to look like.
0 -
Just to update I had to make a different Row number to keep everything indexed I was working off using the rank and window by property but i made a constant and then ranked by the constant to keep the same indexing.
Thank you agian this helped me out alot!
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive