Skip to Content
0
Former Member
Jan 02, 2008 at 02:37 PM

Extraction from Table with dublicate records

17 Views

Hi all.

I have custom data source on ECC side which based on VIEW. The view contains organizations and ministry names in a way there organizations are unique while ministries are dublicated.

like this:

Ministry_code_1 Ministry_name_1 Org_Code_1 Org_Name1

Ministry_code_1 Ministry_name_1 Org_Code_2 Org_Name2

Ministry_code_1 Ministry_name_1 Org_Code_3 Org_Name3

Ministry_code_2 Ministry_name_2 Org_Code_4 Org_Name4

Ministry_code_2 Ministry_name_2 Org_Code_5 Org_Name6

So I've created separate InfoObjects both for Ministry and Organization (with Ministry attribute).

Question how can I upload ministry InfoObject from this table containing dublicate records?

I use BI for NetWeaver 2004s with appropriate trasform rules/ data sources.