The Definitive Guide to Data Quality
I am working with Tfileinputexcel in Advanced settings Generation Mode: Less Memory Consumed for large files(Event Mode) and reading the concerned date field as String. In my requirement, As I need to do some validation I shouldn't read the column as Date.
If the excel cell format is formatted to "MM/dd/yyyy", then this issue will work and I can not change the excel format because we are getting client generated spread sheets.
Please suggest me how to handle this issue in the case ,if the cell format of excel is date and reading in the tfileinputexcel as String.
Calendar c = Calendar.getInstance();
c.set(year, month, day, 0, 0);
LocalDate.of(year, month, day); //2015-12-22
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.