Skip to Content
0
Former Member
Jul 14, 2008 at 09:05 PM

Syndicating Qualified tables

17 Views

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