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.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
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 685 Beast Mode
- 43 App Studio
- 38 Variables
- 656 Automate
- 170 Apps
- 439 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 385 Distribute
- 110 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 111 Manage
- 108 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive