Free Trial

Alteryx Designer Desktop Discussions

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

Exclude Row based on same value in different columns

kw7669
5 - Atom

Hello. I have the below data. And I'm trying to remove rows that are essentially the same. I've created RowIdentifier and RowIdentifier1 columns to show which rows are matching. I need a way to compare RowIdentifier and RowIdentifier1 and then remove one of the rows and end up with the second table. 

 

CompCodeCompTPTotalTradingPartnerVarianceRowIdentifierRowIdentifier1
2140T21408241.398241.3916482.782140214021402140
2140T7320-5416902.925994587.81577684.897320214021407320
2140T7980-6553589.677828176.681274587.017980214021407980
7320T21405994587.81-5416902.92577684.892140732073202140
7320T73200007320732073207320
7980T21407828176.68-6553589.671274587.012140798079802140

 

 

 

CompCodeCompTPTotalTradingPartnerVarianceRowIdentifierRowIdentifier1
2140T21408241.398241.3916482.782140214021402140
2140T7320-5416902.925994587.81577684.897320214021407320
2140T7980-6553589.677828176.681274587.017980214021407980
7320T73200007320732073207320
1 REPLY 1
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @kw7669,

 

There may well be more of an elegant way to solve this but this was the first approach that came to mind and gets us to the correct result I believe! Transposing so we have both Row Identifiers so we can concatenate them before joining back and ordering before uniquing on the concatenated ID field.

 

Jonathan-Sherman_0-1622216612586.png

 

I've attached my workflow for you to download if needed!

 

Kind regards,

Jonathan

 

Labels
Top Solution Authors