Compare Values on a Column and Output Outcome on a different column.

[Eneye]

Hello all,

I'm comparing values within a column, this is what it looks like on excel:

The formula used for count is: =IF(A2<>A1,1,0) and it progresses through the cells as shown in the image.

How can I do this on Alteryx. I've tried using the formula tool, but I can't figure out how to express it.

Thanks in advance.

[IraWatt · Accepted solution]

Hey @Eneye,

To compare different rows with a formula you can use the multi row formula tool:

If you want to learn more about the Multi-Row-Formula Tool the community has some quick and easy videos on the topic here: Interactive-Lessons Multi-Row-Formula

Any questions or issues please ask :)
HTH!
Ira

[Eneye]

Thanks, works perfectly!

[IraWatt]

No worries @Eneye 😄