tFileInputExcel does not have an option to converts the date to string for .xls files

Anonymous — Sat, 16 Nov 2024 08:22:30 GMT

I am trying to create a generic job that will have an .xls file as an input and a dynamic schema since we will be using this for multiple files. This data will then be loaded to a .csv file.

The issue that I am facing is that I could not convert the dates to a desired format.

This is not an issue for .xlsx files since there is an option in the Advanced Settings that converts the data to string with the desired format.

This option is not present when the input is .xls (when the checkbox for Read excel 2007 is unchecked)

Because of this I could not specify the date patterns and it is just getting the format in the .xls file.

I don't think it would be possible to handle the conversion tMap since we want it to have a dynamic schema. I tried using talendDate.formatDate for the transformation but it encountered an error since the type is dynamic and not date.

I also tried to make a workaround which is to create a temporary .xlsx file from the .xls file. This .xlsx file will then be the one to load on the .csv file (with the convert date column to string option checked) but is still not working.

Here is the screenshot of the test job that I made:

Any advice on how to approach this?

Re: tFileInputExcel does not have an option to converts the date to string for .xls files

Anonymous — Tue, 24 Apr 2018 10:45:20 GMT

Hello,

Have you tried to replace your tFileInputExcel component with t<DB>Input to see if it works?

Best regards

Sabrina

Re: tFileInputExcel does not have an option to converts the date to string for .xls files

Anonymous — Tue, 24 Apr 2018 10:51:31 GMT

Hi Sabrina,

My input is an excel file. How will it work if I am going to use a
tinput component?

Thank you.

topic Re: tFileInputExcel does not have an option to converts the date to string for .xls files in Talend Studio

tFileInputExcel does not have an option to converts the date to string for .xls files

Re: tFileInputExcel does not have an option to converts the date to string for .xls files

Re: tFileInputExcel does not have an option to converts the date to string for .xls files