cancel
Showing results for 
Search instead for 
Did you mean: 

Conditional mapping on source file

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member205403
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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