Error in transforming data

[Robert Hames]

I'm attempting to transform an Excel spreadsheet into a custom table. I have a date received in the spreadsheet, and its format is yyyy-dd-MM, and I have a field map for it mapping u_date_received to u_date_received with same format. I have the transform to Enforce Mandatory fields with the option of "Only Mapped Fields". I have also tried it with Enforce Mandatory fields set to "No" with the same result.

When I run the transform, I get an error on every row telling me that date received is a mandatory field. There is data in the spreadsheet for every row, and the format matches.

There are screenshots below from the spreadsheet, the field map and the error I'm receiving on every row.

Anyone have any ideas as to what could be wrong?

[Aman Kumar S]

I have seen this happening a lot of times, I would suggest if you can utilize the source script to convert into relevant format.

That is my suggestion, lets see what experts has to say about this 🙂

[reginabautista]

Perhaps you are mapping with the other date received field and so the date received that's mandatory is not being populated that's why it's prompting the error? On your transform map mapping, check the field name of the source field and validate if you are using the correct field. 

[Ammad Satti]

Hi 

Can you try removing asterisk (*) from Date received header in the spread sheet and try to import. 

Thanks!

[Robert Hames · Accepted solution]

Well, thanks for all the replies, but I figured it out and it's a weird one. The auto-map feature was generating a "Date Received" field, and then somehow another "Date Received" field was being generated without it being in my transform map. That was the one generating the error.

I removed the auto-generated one, and created one myself, and it worked first time.

Thanks for the help!