hi community I have an input with customer balances from x1 to x720 am looking to calculate two sets of sequential differences/movement across these columns * MX the difference between the consecutive balances of Xs* MX1=X1-X2 * MX2=X2-X3 * MX3=X3-X4 * .... * M719=X719-X720 * MT the difference between the consecutive MXs* MT1=MX1-MX2 * MT2=MX2-MX3 * MT3=MX3-MX4 * ..... * MT718=MX718-MX719 Small example for clarity input table output table given that i need to handle 720 columns am seeking advice on the most efficient way to set this up in Alteryx. any suggestions in tools workflows or scripting would be greatly appreciated Thanks in advance for your help

Calculating sequential differnce

hi community

I have an input with customer balances from x1 to x720 am looking to calculate two sets of sequential differences/movement across these columns

Small example for clarity

input table

output table

given that i need to handle 720 columns am seeking advice on the most efficient way to set this up in Alteryx.

any suggestions in tools workflows or scripting would be greatly appreciated

Thanks in advance for your help

Input

Output

THANKS .. i really appreciate it

its working as i want