We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

two row comparison using multi row tool

Rive11115
6 - Meteoroid

I'm using two files, file C and file P to extract columns A through F. I'm arranging them by Token_P first and then by CC_P to get related transactions consecutively. I need help creating a "New Field" column using multiple rows or any other tool, that would flag rows 2&3 as related and rows 4&5 as related Can someone please help with this formula: If the amount_P matches the above amount_P AND Token_P matches the above Token_P AND either amount_P matches the above amount_P OR the sum of amount_P and the above amount_P equals zero THEN the entry in the "New Field" should be "related"; otherwise, it should be empty. I have included an excel with the data.

1 REPLY 1
cjaneczko
13 - Pulsar

The fields you are referencing do not exist in your data set. Which fields are amount_P and Token_P? I dont see how Rows 2 and 3 are related, nor 4 and 5? What is similar to one another?

 

image.png

Labels
Top Solution Authors