on 04-22-2010 3:08 AM
Hello
In Import manager we have to import a delimited text file into MDM.The target MDM field is "Quantity".
The source file has 2 fields "DU Quantity" and "CU Quantity" on a record.
Additionally we have "RECORD_TYPE"(values are DU or CU) on the source text file
The situation is
IF RECORD_TYPE=DU
MAP "DU QUANTITY" to "Quantity"
IF RECORD_TYPE=CU
MAP "CU QUANTiTY" to Quantity"
END
Is the above situtaion possible in Import manager?
Regards
Thanks
Kalyan
Hi,
I agree with Trang, Such type of Format conversion should be done from either source side or at Middleware like PI.
But just in case you are getting data in below format:
Record Type DU Quantity CU Quantity
DU 10
CU 13
i.e. if Record type is CU, then the CU Quantity field is the only field that contains value and DU quantity Field value is blank.
if the record type is DU, then only DU Quantity Field has value and CU Quantity is blank.
In the above mentioned case you can import Data Into MDM Quantity Field using Field Partitiioning and Setting up conversion filters.
To do so follow the below mentioned steps.
1. Create a partition Field which will be combination of DU Quantity and CU Quantity.
So considering above example, your Value in partition Field will look like 10;<NULL> and <NULL>;13
Here ';' is the delimiter.
2. Map this partition field of DU Quantity and CU Quantity to MDM Quantity Field.
3. Right click on the Mapped Partition Source Field in the Import Manager in "Map Field /Values" Tab and select "Set Value Conversion Filter"--->"Multiple"
4. Add two filters as to replace "<NULL>;" and ";<NULL>" with Space. To do so, click on "Add" in the "Set Value Conversion Filter" Window and select "Replace".
5. After Applying Filters mentioned in step 4, values from Source partition field will look like 10 and 13.
6. Perform Record matching step based on appropriate field, specify import action and import data..
In this way you can import data from two quantity fields into 1 MDM quantity field from the structure mentioned above.
Hope this helps. Revert if any issues.
Regards,
Shiv
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
I believe you can't with the import manager as it just takes the data and maps to appropriate field in the repository. But if you are getting the data from SAP ERP can use the distribution model to filter what data can be sent to your MDM port or you can use XI/PI to do the filtering and put into the approprate MDM port and then create the import map for that port.
Regards,
Trang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.