Reversing the columns values in Alteryx - making it dynamic

Question

Hi,

What's the most efficient way to dynamically reverse the numbering count of column in a new column for different groups?

I have this -

NumberValuesGroup11%X22%X36%X47%X14%Y23%Y32%Y410%Y

Want this -

NumberValuesGroupNEW11%X422%X336%X247%X114%Y423%Y332%Y2410%Y1

Can this be dynamically adjusted, so if the MAX of Number column in 10, the NEW column starts to reverse the count from 10 - without changing the order of the original data

Any help is appreciated

grazitti_sapna · Answer

Hi @Anirudh_A

Adding a Tile tool with summarize in workflow will give you required output dynamically. You can refer attached workflow.

Thanks

Solution.yxzp

caltang · Answer

Hi @Anirudh_A - it's been some time since you last posted. Did any of the above solve your need? If yes, kindly mark them as accepted solutions to close the thread.

Thanks!

sparksun · Answer

Here is my way,if the Maximum number is 10, just change 5 to 11.