on 06-17-2016 4:31 PM
Hi - I have a flat file and its has got close to 100 records and out of which 15 are duplicates . I have my keys in place , How do i display the duplicate records in a table ? i can use distinct option to have only originals in one table.
Any smart and easiest approach to get this done ?
Thanks,
AJ.
Hi AJ,
Try this.
Create a new column in Query Transform and name it as COUNT(int) and Map this column with column name and apply group by.
In the next step take another Query transform and in where give COUNT>1 and only the duplicate records will be loaded to target table.
Thanks,
Ravi Kiran.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
One way would be to create a distinct set, then inner join the distinct set with the original. May have to do some clean up, but by only sourcing the records from the original set in the query, it should provide everything that is a duplicate of something that is unique.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.