Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Rows comparison

noopurjain
8 - Asteroid

Hello,

 

I want to create a workflow that creates a new column (Flag) and mark "Keep" when account, code and code2 matches and price does not. And mark "Remove" when account, code, code2 and price matches. Need "remove" for single entries (row 8) as well.

 

I tried doing it using multirow formula. Below is the logic I used. I don't understand why it did not work. 

 

Group by on Account, code, code_2

Expression:

IF [Row-1:price ]=! [price] THEN "keep" ELSE "remove" ENDIF

 

4 REPLIES 4
binuacs
20 - Arcturus

@noopurjain I tried your formula and it worked for me. Can you check the flag1 values are expected?

 

binuacs_0-1656540396022.png

 

Hi @noopurjain 

 

You need to put ! before = so it's (!=) for not equal to, instead of =!

DataNath
17 - Castor

Hey @noopurjain not sure if I'm overcomplicating this a bit but the attached flow arrives at the desired output you provided.

 

DataNath_0-1656540454517.png

 

noopurjain
8 - Asteroid

Thanks @DataNath it worked! 

Labels