Showing results for 
Search instead for 
Did you mean: 

Table without Key column

Former Member
0 Kudos

Hi guys,

I am almost stuck with one report requirement which is to remove duplicate records. Duplicate records come from a table which does not have any Primary key/Foreign key/Unique constraint and that's why so many repeating records.

Now one of these columns is used in a join to extract other information from different tables. But when i try to fetch using DISTINCT query goes in infinite loop and does not respond.

Can anybody suggest me a solution to this problem at BO level? Do I tell Business analyst that the source of problem lies in the table without any key.?


Manish Amin

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos


this link usefull for you:


All the best,


Answers (0)