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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.