Read file per file inside folder

[Anonymous]

Hi,
I just wonder how do Talend read file inside specified folder and then do extraction as usual. After finished data extraction, move that file into another folder.
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.
After that excel files extracted, that file will be moved and saved into another folder "Folder_Out". Is it possible for Talend to do this?
Plz help me

Regards,
Kal

[Anonymous]

Hi ae_kel29,
I doubt that there are some extra spaces in your source file.
Do you use tfileinputdelimited component? checkout the option "Trim all columns" and "check each row structure against schema" in Advanced settings to see if this issue still repro.
See pic
Best regards
Sabrina

[Anonymous]

Hi,
I used tFileInputExcel and already checked the "Trim all column". See my job

[Anonymous]

Hi,
I think the issue don't exist in tfilelist-->tfileinputExcel work flow.Because I have a demo job as yours(see pic). Suppose that something wrong with the component Extract row and tMap. How do you set these component? Could you share it on forum.
Best regards
Sabrina

[Anonymous]

Hi,
Thanks for your response. But maybe the explanation below may help you:
File 1
--------
AAAA 2006
aaaa 2006
File 2
--------
BBBB 2009
bbbb 2009

Expected Output
-------------------
AAAA 2006 | aaaa 2006 | 2006
BBBB 2009 | bbbb 2009 | 2009

Current Output
-----------------
AAAA 2006 | null | 2006
BBBB 2009 | bbbb 2009 | 2009

You can see my expected result and current result that i want. What you've done is direct load meanwhile if you carefully take a look at my expected result, there's something i split out.
Rgds,
Kal

[Anonymous]

Hi,
I have six different excel files in a folder and each file contains different data.Each files data must be loaded into different tables in MSSQL. The folder maybe loaded with new files with the same name frequently.I want a job in Talend such that the files are loaded automatically into MSSQL whenever triggered.Is this possible in Talend. I am new to Talend and thus need help in it.
Please help me out with this. :/
Regards,
Ritesh.