topic Re: how to get data using tfilelist component in Talend Studio

how to get data using tfilelist component

RAJ6 — Thu, 05 Oct 2017 11:13:24 GMT

Hi All,

I have to do below requirement
I have two Hundred excel file in same folder
My file name is P_19Jun2017 and P_20Jun2017.
How to get data from excel files using tfilelist component based on file name (file name like Date).
I need to get excel file data based on max of date for tfilelist_1 component and (max of date - 1) for tfilelist_2 component
Then I have to do join for both file using tmap.
I need to create job below like screenshots.

Anonymous — Thu, 05 Oct 2017 12:46:08 GMT

Hi ,

Why did you use 2 tFileList if you have only 2 files ? The iteration is useless no ?

Personnaly I take the problem more like that :

You can initialise some globalMap in tJava in function of some properties of your file.

In you tFileInput use your variable in the de name file var.

Good luck.

RAJ6 — Thu, 05 Oct 2017 12:54:56 GMT

Thank for your reply. can i get that java code

Anonymous — Thu, 05 Oct 2017 13:20:22 GMT

Create 2 contexts var String with default value = INIT

then in your tJava

if(context.file1.equals("INIT"))

{

context.file1 = ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"));

}

else

{

context.file2 = ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"));

}

And in the tFileList, order by "Date of Modif"

Or something like that .

Good luck ,

SGV