Comparing 2 columns from 1 Table

Hi everyone,

I have a Table with 2 id's with other relevant data columns

A-MakerID will be always populated and it has a duplication issue, so I wants to remove records which has any values in AA-MakerID column for A-MakerID

so Take an example because A-MakerID - '1075220' has a multiple values in AA-MakerID so remove all '1075220' id from the data table & same should be for A-MakerID - '1073310'

but as A-MakerID - '1075199 & 1075459' doesn't have any values in AA-MakerID so this remain as this result we wants at the end

A-MakerID	AA-MakerID
1073310
1073310	1073310
1075199
1075459
1075220
1075220	1075199
1075220	1115708
1075220	1458652
1075220	2653693

Kindly help on this & Thank you in advance

Workflow

Datasets

Developer Tools

Data Investigation

Accepted answers

Emmanuel_G

@kushalb

Find attached the way of doing this.

Let me know if there is any issue. 🙂

Please do not hesitate to mark this answer as solution if it helped.

Comparing 2 columns from 1 Table.yxmd

All comments

Nick-C

Hey @kushalb - I think a filter would work here to look at !IsNull([AA-MakerID]) ?

kushalb

filter won't work here as there are duplicate values and need to consider that for ex. if A-MakerID - '1073310' has 10 rows and any value contain in AA-MakerID column for that id then all 10 rows needs to be removed from the population

Emmanuel_G

@kushalb

Find attached the way of doing this.

Let me know if there is any issue. 🙂

Please do not hesitate to mark this answer as solution if it helped.

Comparing 2 columns from 1 Table.yxmd

Nick-C

Hey @kushalb - I think you can do this nicely with a join

Let me know if this works (if it does please do mark it as a solution!)

Workflow for Kushalb.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703