I am reading an Excel file (XLSX) that has some Date type columns. If one of those Date cells do not contain a date, the entire record is rejected and I get a message like the following:
The cell format is not Date in ( Row. 4689 and ColumnNum. 9 )
Is there a way to retain the entire record, but just ignore the non-date data?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema