Mapped 2 fields on the basis of 3 mapping fields

[rupaliqlik]

Hi Experts,

I have a one requirement.In my datamodel I have one field ERP_Customer_ID which contains all ID's.I have received one more excel  file which contain ERP_Customer_ID,JDE_Customer , I5_Customer,Network and SSO fields.My requirement is that I want to bring Network and SSO fields .If ERP_Customer_ID From Datamodel does not matched with  ERP_Customer_ID in excel then it should map with JDE Customer .If JDE customer also not matched with ERP_Customer_ID from datamodel then It should map with I5 Customers.So basically I want to bring SSO and network fields from excel to datamodel. Here I have to bring 2 fields so I can't use applymap as per my knowledge. Kindly help me I can't understand how I'm going to achieve this.

ERP_Customer_ID

JDE_Customer_ID

I5_Customer_ID

Network

SSO

sunny t

Thanks,

Rupali Ethape

[dplr-rn]

Why dont you transform your excel load into a table where ERP_Customer_ID, JDE_Customer_ID , I5_Customer_ID is combined into a single column

e.g.

ERP_Customer_ID

Network

SSO

something lke below

load

ERP_Customer_ID, 
Network, SSO

from excel

concatenate

load

JDE_Customer_ID as ERP_Customer_ID,
 Network, SSO

from excel

concatenate

I5_Customer_ID as ERP_Customer_ID

, Network, SSO
from excel