[resolved] 'Fetching values from lookup tables in excel using Talend
Hi, I was trying to load data from an excel sheet which had formulized fields. The values though being displayed were actually just formulas. These values were not being accepted by talend. Is there any way to read them or do I need to convert them into proper values before working on them?
Hi Esabot,
I have marked this topic as resolved. Please change the title to 'Fetching values from lookup tables in excel using Talend'. I made the post when I myself was not sure what the problem exactly was. The current title could be misleading for other people.
Hi All,
Just made another observation in this case. Though unhiding all the sheets in excel turns out useful, it doesn't work on dates. Integers, floats and string based values have no issue when it comes to load the data in database. But it doesn't work with dates.
To tackle this, I tried making multiple logics in java, sql and in talend. But after spending numerous minutes and hours I found a tiny option in tExcelInput.
In Advanced settings of tExcelInput check the 'Convert date column to string' and select the columns with date. It helps in parsing dates easily.
Hi You can edit the title of your thread by editing your initial post (I just did it for you on this one). Regarding the use of "Convert data column to string", you may want to share this use case as best practice in the dedicated forum: http://www.talendforge.org/forum/viewforum.php?id=40 Up to you. Many thanks Elisa
