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