Calc. Sequential Difference

[WassimAB]

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!