Table without Key column

[Former Member]

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

Thanks,

Manish Amin

[Former Member · Accepted solution]

Hi,

this link usefull for you:

[http://businessobjectsguru.blogspot.com/2008/02/find-and-remove-duplicate-rows-from.html]

All the best,

Praveen