Comparing 2 columns from 1 Table

[kushalb]

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

[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 · Accepted solution]

@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.

[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!) :)