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. 14226320142263211414505114200440142004401420044114132970141329701413297114175311

Comparing data in each row of a single column

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

Dynamic Processing

Preparation

Accepted answers

RodL

You can use the Multi-Row Formula tool. It allows you to assign values to the current row relative to row values above or below the current row.

Since you are assigning the flag based on a "future" row, the expression would be something like...

IF Row+1:RefNum != RefNum THEN 1 ELSE 0 ENDIF

bb213

already solved- thanks.

All comments

RodL

You can use the Multi-Row Formula tool. It allows you to assign values to the current row relative to row values above or below the current row.

Since you are assigning the flag based on a "future" row, the expression would be something like...

IF Row+1:RefNum != RefNum THEN 1 ELSE 0 ENDIF

Faithz

Thank you RodL, I need to definitely learn some more about how each tool functions.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703