Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Table without Key column

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
Former Member replied

Hi,

this link usefull for you:

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

All the best,

Praveen

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question