Question of how to mark or pass data for certain amount of records

mhouk

so I have a table that looks similar to the following below.

What I want to do is to label each activity in each record for each property.

Only 5 different activity types don't change, but the number of records changes, so I cant count rows.

domo example.xlsx

Godiepi

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

Domo_Dojo_Help_04042023.txt

your output should look like this (the highlighted columns are your original fields in the spreadsheet)

Godiepi

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

Domo_Dojo_Help_04042023.txt

your output should look like this (the highlighted columns are your original fields in the spreadsheet)

mhouk

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.

domo example 2.xlsx

Example2.txt

mhouk

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!