cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicate records

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member208402
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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.