Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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