Automap Values feature for Manual Import
Q;
We have a Import Map, which the end users uses to do Mass inserts into the Main table as & when required. The end user runs the Import manually from the Import Manager.
We have about 20-25 columns which are of type lookup flat. Hence every time any new values are added to these columns in the source, the user would have to manually go and click on the Automap for values for all the necessary fields.
Is there any property which we can set so that, the Import map automatically performs an value Automap for all the lookup fields when it is loaded?
The source file format is an excel template provided to the user.
We are currently using SAP MDM 5.5 SP06 (Version 5.5.63.73)
We have about 20-25 columns which are of type lookup flat. Hence every time any new values are added to these columns in the source, the user would have to manually go and click on the Automap for values for all the necessary fields.
Is there any property which we can set so that, the Import map automatically performs an value Automap for all the lookup fields when it is loaded?
The source file format is an excel template provided to the user.
We are currently using SAP MDM 5.5 SP06 (Version 5.5.63.73)
Ans:
Refresh all the lookup tables in MDM with remote key mappings.
Then perform perform manual import to Main table. All the Lookup field values will auto map.
Then perform perform manual import to Main table. All the Lookup field values will auto map.
Ans1:
Under same configuration optiosn choose and select appropriate values for -
Default MDIS Handling > a. Automap Unmapped handling > Yes
b. Unmapped Value handling > Add
Default MDIS Handling > a. Automap Unmapped handling > Yes
b. Unmapped Value handling > Add
Ans2:
Just check if this happens for all the lookup tables or the only ones used for Matching Records. For second case, use some different matching keys and try the import. Automap feature is available for MDIS only.
