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.

[AbhishekGardade]

Can you please review field maps under transformation map and ensure all column names are distinct?

Can you please try deleting the field and then reloading the excel directly without creating a new field?

Please mark as Correct Answer and Helpful, if applicable.
Thanks!
Abhishek Gardade
Hexaware Technologies

[Ankur Bawiskar]

Hi Shekhar,

It seems the date format coming from excel or csv file is not mapped properly to the target date format.

Can you check the field map for the date field?

When you created data source did you specify the Header row as 3 instead of 1?

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]

Yes i mark header row as 3 log error gives like this 

[Ankur Bawiskar]

Hi Shekhar,

the error is saying that it is unable to format the date for u_lastscandate

check the field map for this field in transform map

the incoming date format is YYYY-dd-MMTHH:MM:SSZ

Have you set this format while mapping

check screenshot below

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