Hi Alteryx Community,
I have an input table with customer balances from x1 to x720. I'm looking to calculate two sets of sequential differences across these columns
1. MX The difference between consecutive balances
MX1 = x1 - x2
MX2 = x2 - x3
......
M719 = x719 - x720
2. MT The difference between consecutive MT values
MT1 = M1 - M2
MT2 = M2 - M3
...
MT718 = M718 - M719
Here’s a small example for clarity:
Input Table:
Desired Output Table
Given that I need to handle 720 columns, I'm seeking advice on the most efficient way to set this up in Alteryx. Any suggestions on tools, workflows, or scripting techniques that could streamline this process would be greatly appreciated!
Thanks in advance for your help!