Issue in creating source fields on excel transformation.

[NA13]

I have an issue in transformation. There are 2 fields in excel - Sales Renewal Criteria for A4 Commercial Printing track, Sales Renewal Criteria for A3 Commercial Printing track. So when we load the sheet its creating only one field with the backend name as u_sales_renewa_printing_track in source table. Even if I create 2 new fields on source table its not considering those fields. Can anyone let me know how i can have 2 different fields with the data mapped in source table.

[Ankur Bawiskar]

@NA13 

ensure the column label in excel are different for you to create 2 fields in import set staging table

[NA13]

Hi , thanks for the reply , The fields are different but the backend name its considering for the 2 different fields is same. So its not considering the 2nd field( as there is only little difference in both field label).