Source file structure when importing a qualified table

[Former Member]

Hello MDM:ers

I need to import a qualified table into the following repository

(it is simplified to illustrate the problem):

Main table: Products

Fields: ID (int), Name (Text), Part number (Qualified)

Qualified Table: Part Numbers

Fields: Manufacturer (Lookup), Part Number (Text)

Lookup table: Manufacturers

Fields: Name (Text)

The source file is a very large text file that has the following structure:

Part ID		Name	Part no. Manuf 1	Part no. Manuf2
123		Nut	ABC			XYZ
456		Bolt	DEF			QWV

The result I’m looking for Is to map a file structured a above so that two main table records are created (Nut and Bolt) which both have two qualified table records for each manufacturer. I have not been able to create such a map. I have tried to partitioning and combining fields without success.

I have no problem creating the map if I manually restructure the file to look like:

Part ID		Name	Manufacturer 		Part Number
123		Nut	Manufacturer 1		ABC
123		Nut	Manufacturer 2		XYZ
456		Bolt	Manufacturer 1		DEF
456		Bolt	Manufacturer 2		QWV

It where a way to import the file directly in MDM without restructuring it?

[Former Member · Accepted solution]

Hi Alexander,

I think you can use the feature of Pivoting in Import Manger, to fullfill your requirement. It is a transpose requirement.

You will have to choose fields intelligently and pivot them.

Kindly try it.

Hope it helps.

*Please reward points if useful.

Thanks and Regards

Nitin jain

[Former Member]

Thanks!

I have it working in the import manager.

However I was not able to get it to work using the import server. Is it not possible to use this functionality in batch import mode?

I couldn't find anything about it in the reference guide.

[Former Member]

Hi Alexander,

MDIS will not work fine if you have multiple tables as the mapping is saved only for 1 table. If you have multiple tables then after performing the process of Pivoting/Reverse pivoting, you will have to use joins.

Join the other tables as Lookup in the Main Table

Save all your configuration in a map. And then configure the map in the port.

It should then work with the MDIS also.

hope it helps.

Thanks and Regards

Niitn Jain

[Former Member]

Hi Alexender,

yes, you can achieve this using Reverse Pivoting, in the import manger, when source table is selected then --> under source hierarchy, select both the fields Part no. Manuf 1 and Part no. Manuf2

and then right click then create Reverse Pivot Table, you will get the desired result.

Note, then for mapping source structure to target structure, select source table as sourcetable<reverse Pivot> and then coreesponding to source field map the destination fields.

Hope it will help you,

Thanks in Advance.