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.

Expression

Accepted answers

IraWatt

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

Workflow.yxmd

All comments

IraWatt

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

Workflow.yxmd

Eneye

Thanks, works perfectly!

IraWatt

No worries @Eneye 😄

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335