The cell format is not Date in

One Star

The cell format is not Date in

Hi,
I'm using the excel source data to load the data into the relational table and I'm getting below error.
Can anyone please help me?
The cell format is not Date in ( Row. 2 and ColumnNum. 6 )

Thanks,
One Star

Re: The cell format is not Date in

Are you trying to insert non-date data from the excel into a date data in the relational table? Maybe you have to format it into a date first.
Six Stars

Re: The cell format is not Date in

Hi,
I think you have 2 solutions :
- convert your excel column file into date format and import your file
- import your file and conevrt the string date into date (use TalendDate.parseDate("yyyy-MM-dd", row1.yourData))
Six Stars

Re: The cell format is not Date in

Hi,
Can we consider this topic as resolved ? If yes, can you prefix this title topic with ?
Thanks,
Arnaud