Good Day All,
I am new to Alteryx and trying to figure out how to compare consecutive rows from a individual column and then give 0 if it matches and 1 if no match.
example:
reference number
1422632 | |
1422632 | |
1414505 | |
1420044 | |
1420044 | |
1420044 | |
1413297 | |
1413297 | |
1413297 | |
1417531 |
then get a output that looks like below.
1422632 | 0 |
1422632 | 1 |
1414505 | 1 |
1420044 | 0 |
1420044 | 0 |
1420044 | 1 |
1413297 | 0 |
1413297 | 0 |
1413297 | 1 |
1417531 | 1 |
Solved! Go to Solution.
Hi, I have a very similar issue/need but am not able to reconcile the output of the Summarize Tool I use when counting distinct non-null values in my rows and using the Multi-Row formula tool using the following expression:
IF [SO_ORDER_ID] != [Row-1:SO_ORDER_ID] OR [Row+1:SO_ORDER_ID] THEN 1 ELSE 0 ENDIF
I end up with the correct value I'm expecting in the Summarize Tool, however the value from the above expression in the Multi-Row formula tool ends up being less than expected by a fair amount. Any thoughts on how I can tweak the logic or settings used in the Multi-Row formula to have the two values be equal to each other?