Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Thanks,
Rupali Ethape
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