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!
Solved! Go to 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 : )
Helps a lot, thank you!!
Very helpful, thank you much!!
Thanks a lot! I also appreciate the detailed notes on each tool 🙂
Happy to help : ) @jaydelim16
Cheers and have a nice day!
Hello
Do you have examples of use of chain ladder using Alteryx ? Thanks