A quick note as #Alteryx19 closed in London that should make for a great weekend. I've been told by Alteryx support that latest release of Designer 2019.3 – version 2019.3.5.17947 fixes the CReW Macro issue.
Within my Alteryx workflow I need to calculate the difference between each numeric column of data (e.g. monthly data) and create "delta" columns that calculate that difference. Success of the solution depends upon both not needing to update the workflow (e.g. dynamic calculations) and the performance of the solution (not needing to transpose the data).My friends Thales & Esther (EstherB47) recommended transposing the data.
When dealing with this kind of situation, the best you could do is to transpose your columns into rows.Not me! I know how to avoid the transpose tool and how to dynamically calculate formulas. Try this yourself and don't use a Transpose Tool or Multi-Field Formula. Imagine hundreds of columns with thousand or more rows. Here's some simple input data:
This way you can work with Multi-Row Formula, that can be much more flexible in regards to what you're looking for.
So basically use Transpose Tool and you'll have a better situation to compare previous records against the current ones.
"[" + ToString([Name]) + "] - [" + ToString([Row-1:Name]) + "]"Step 6: Use a sample tool to remove the calculation of Delta from the first record.