Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Removing Row

Simon1187
8 - Asteroid

Hi there, 

 

I am trying to remove the return money and paid money in from payment from the same customer Id. Could you please help me with how can I remove them? Sample data is below: 

 

 

 

 

 

 

sample.PNG

 

 

 

 

 

Thanks,

3 REPLIES 3
atcodedog05
21 - Polaris

Hi @Simon1187 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1631186638254.png

 

Removing rows where paid is opposite and customer id is same.

 

Hope this helps : )

Simon1187
8 - Asteroid

Hi @atcodedog05 

 

Thanks, 

atcodedog05
21 - Polaris

Happy to help : ) @Simon1187 

Cheers and have a nice day!

Labels