Rows comparison

[noopurjain]

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

[binu_acs]

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

[christine_assaad]

Hi @noopurjain 

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

[DataNath · Accepted solution]

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

[noopurjain]

Thanks @DataNath it worked!