The scenario is like this, I want to extract data from excel file and load into mssql. However, there are several files of excel and I put those files inside "Folder_In" folder. Also, there may be another excel files will be added into "Folder_Input" and need to be extracted.
There are two folder with name "Folder_In" and "Folder_Out". "Folder_In" is used to stored the excel files which the data of each files will be extracted and once a file has competed extracted, that file will be moved-out and will be stored in "Folder_Out".
I just wonder, i have 2 files with same format inside a folder which refer to year 2006 and 2009 and i wants to extract these files automatically by using tFileList. I was successfully extracted the data each year with respective values but the year was replicate to 2006 even though the values are for year 2009.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables