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.

[palanikumar]

Hi,

Are you using import set for this purpose?

If yes then you need to create the additional fields in import set table. Import set table will not auto create if any additional field added to the data source. Once it is done, you need to map the new field with target field in transform map.

[NA13]

Hi Thank you for your response , i am loading the data through an excel. So if i create any additional fields on source table the data is not getting mapped. The fields are automatically created once i load the sheet and its causing this issue considering both the fields are same and its not considering them as different label.

[palanikumar]

Are you using import set table?

[NA13]

yes