Qualified Tables

[Former Member]

I have my source file format as below

Products|Price01|Quantity01|Price02|Quantity02

A | 2.00| 10 | 3.00| 12

B | 3.00| 9 | 4.00| 6

For example purposes I gave only 2 sets of Price and Qty fields but I have totally 12 sets. Now I do not want to create Main table with 12 sets of price and qty field instead of that I want to use a lookup qualified table.

Can somebody please help how to use qualfied lookup table in this case. This is an urgent requirement.Quick answers would be appreciated.

[Former Member]

Hi Rajesh,

In the MDM Console, just add a qualified (Flat) table to your repository. In this new table, add all the fields you want in them and mark them as qualifiers. You should name one field as a non-qualifier and just make it autoID.

Now, in your main repository, add a field that is of type "Qualified [Flat] (multi-valued).

If this is to general for you, just let me know and I'll send you a more detailed description.

With kind regards,

Gerwin