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
Solved! Go to Solution.
Hey @noopurjain not sure if I'm overcomplicating this a bit but the attached flow arrives at the desired output you provided.
Thanks @DataNath it worked!