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
Solved! Go to Solution.
Hey @kushalb - I think a filter would work here to look at !IsNull([AA-MakerID]) ?
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
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.
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!) :)