How to load the data by mapping with different existing fields in the table

[Abhilasha G T]

Hi Team,

we have ONE table , here we can see the  columns like below,

Characteristic , characteristic value and Sold product

in my excel sheet having data under  the column name as A END and B END , instead of Characteristic and characteristic value

A END	B END
Location A	UK
Location A	UK
Location A	UK
Location Z	US
Location Z	US

i need  to load the data  to those two columns Characteristic and characteristic value

how to achieve this ?

[Sagar Pagar]

Hi @Abhilasha G T,

You can load data and then use transform map to map the columns (Mapping assists) as below-

A END--> Characteristic

B END --> Characteristic value

Thanks,
Sagar Pagar

[Abhilasha G T]

Hi Sagar,

requirement is different, sorry i didnt written clearly,

we can see the  columns like Characteristic , characteristic value in a table

in my excel sheet  we have a column like SO_AEND_ADDRESS (location A) and SO_BEND_ADDRESS (location Z) under those we have a data , that is ntg but characteristic values for locations A and Z 

like for location A , characterstic value is UK- London

 for location Z ,   characterstic value is Hong kong - sino Favor

how to load the data is available in excel to that table  for Characteristic , characteristic column