Creating Import Set error from CSV file

[Shekhar Deshin1]

Hello,

I am trying to create Import Set from CSV file for data source.I am getting following error in Red.

I do not have any duplicate column.I am giving header row as start from 3 but seems like csv file taking by default row as 1.

When i checked Import Logs it shows date cause format

Please suggest how to fix the issue from the CSV file load data.due to this i unable to complete transform map.

Thanks,

Shekhar.

[Shekhar Deshin1]

I changed Target table column name as last scan and changed date format also how ever still facing same issue with Duplicate column names 

[Shekhar Deshin1]

My challenge here is We are getting csv file format.While loading it with Sheet Number 1 and Header row 1 it runs successfully and when i check any loaded data i do not see anything there.(due to 1st 2 rows are having scattered column data).

When i run with Header row as 3 where my actually data start from proper column it gives me "duplicate column names"

Please suggest how we can resolve csv file.

[Ankur Bawiskar · Accepted solution]

Hi Shekhar,

the csv file should be clean and as you said the data should not be scattered and should follow the same format as used during first data load

Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Shekhar Deshin1]

In Field mapping