Hi,
When I syndicate a record from a repository, the qualified table information is multiplied by number of information in another qualiefied table. For example.
-
Main Table Product, Field - Material ID = A37878F
Qualified Table Plant,
Fields Values
Plant | MFG_Part = PL02 | Gasket988
PL04 | Bearing833
Qualified Table MRP
Fields Values
Plant | MRP = PL03 | 90
PL05 | 120
-
When I syndicate this one record, the output file looks like.
A37878F PL02 | Gasket988 PL03 | 90
A37878F PL02 | Gasket988 PL05 | 120
A37878F PL04 | Bearing833 PL03 | 90
A37878F PL04 | Bearing833 PL05 | 120
I want the record to look like.
A37878F PL02 | Gasket988
A37878F PL02 | Gasket988
A37878F PL03 | 90
A37878F PL05 | 120
Is it possible? Any help would be greatly appreciated.
Thanks
Subhash