Data load from Excel file to existing table

[Kohei4]

Hello

I am trying to load data from excel file to existing staging table.

What I am expecting is that the date would be loaded into the existing field.
However, new field was added and the data was loaded to the added field.

In the Excel file, header is the field name.
The staging table is not created by me but OOTB table that is used for integration.

[Tony Chatfield1]

Hi, if a new field was created in the staging table then it sounds like the header name for the field in the Excel file was not an exact match for the existing staging field. 

[Maharshi Chatte]

Hi,

The names in the excel and the fields in the table is probably not the same . One solution can be rather than directly uploading the excel you can click on import -> download excel template .So the import excel template will be downloaded and inside the excel template you can copy your data and upload the excel template with data or you can copy the heading names from the excel template to your own excel and then upload that.

Please mark the answer as correct & helpful if it was useful

Regards,

Maharshi

[Maharshi Chatte]

Hi,

If my answer was useful please mark the answer as correct/ helpful to close the question

Regards,

Maharshi