Triangle Data Transpose

[jaydelim16]

I am looking to update the data triangles on the "input" tab to obtain the triangles on the "output" tab of the attached.  Basically, the values in the last diagonal in the input triangles should become the first column of the output triangles, and so on.  Thank you!

[ncrlelia]

Hi @jaydelim16,

Please see attached my suggested solution.

Hope it helps.

Cheers,

Lelia

[messi007]

@jaydelim16,

Please see below :

Attached the workflow,

Hope this helps!

Regards

[atcodedog05 · Accepted solution]

Hi @jaydelim16 

Here is my take on the interesting usecase 🙂.

Workflow:

1. Using record id tool to set row id.

2. Using transpose tool to convert data columns to rows.

3. Using filter tool to keep only non emppty rows.

4. Using multir-row formula tool setting col order id by grouping on record id.

5. Using sort to reverse on col order id.

6. Using multir-row formula tool setting col rev order id by grouping on record id.

7. Using join tool to map and get reverse col order id's col name.

8. Using crosstab to convert it back to table.

Hope this helps : )

[jaydelim16]

Helps a lot, thank you!!

[jaydelim16]

Very helpful, thank you much!!

[jaydelim16]

Thanks a lot!  I also appreciate the detailed notes on each tool 🙂

[atcodedog05]

Happy to help : ) @jaydelim16 

Cheers and have a nice day!

[Barp77]

Hello

Do you have examples of use of chain ladder using Alteryx ? Thanks

[atcodedog05]

Hi @Barp77 

What's chain ladder? can you explain more about this? And start a new thread for this.