Presentation of value changes accross multiple columns in one column

Question

Hi all,

I have an interesting data transformation to do, but did not yet have a good idea how to do it in Alteryx. I hope anyone here has a good idea! :)

I have rent payments, e.g. a payment pattern, in multiple columns, each representing one month. Over time, these payments can change from one month to another. I want to present these changes in extra columns.

An example data set and another detailed description can be found in th attached file.

I'm really curious about your suggestions for a solution.

Thanks a lot in advance!

Greetings

Rent payments_pattern.yxmd

FinnCharlton · Accepted Answer

Hi @FlorianH , give this workflow a go. Not sure it's the most efficient way of doing it, but gets you your answer. Hope it helps!