topic Re: How to insert tfilelist variable in table in Talend Studio

How to insert tfilelist variable in table

Anonymous — Tue, 28 Nov 2017 09:45:11 GMT

Hi guys,

I'm Using a tFileList and a tFileInputPositional to read files from some subfolders and Insert the data in a sql table.

I would like to insert also in the sql table a new column with the folder name (given by the tFileList).

How can I do that?

I leave you with a print of my job:

Thanks,
Miguel Cunha

Re: How to insert tfilelist variable in table

Anonymous — Tue, 28 Nov 2017 09:48:59 GMT

Hi
Add a tMap before tDBxxxOutput component, add a new column and set its expression with the global variable.

Regards
Shong

Re: How to insert tfilelist variable in table

Anonymous — Tue, 28 Nov 2017 10:26:07 GMT

@shongthank you for your help.

I did what you say but the output was null for all columns.

Am I doing something wrong?

Re: How to insert tfilelist variable in table

Anonymous — Tue, 28 Nov 2017 10:36:24 GMT

You have to map your data ... just with drag and drop

Capture.PNG

Re: How to insert tfilelist variable in table

Anonymous — Tue, 28 Nov 2017 11:05:12 GMT

@sgvStill not working.

Now all columns ourtuput is ok, except the variable one.

Is the variable ok? ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))

Re: How to insert tfilelist variable in table

Anonymous — Tue, 28 Nov 2017 13:08:45 GMT

It's depend of the name of your variable.
So your tFileList have a Talend Name and a Personnal name (default : personnal name = talend name).
for exemple :

Here, personnal name is "azerty" and TalendName is "tFileUnarchive_1"

So what is the purpose of that :

When you want to use a global variable, you have just to write this : "azerty." and then if you press "Ctr+space", talend will give you every global var generated by the component.

like this :

Then, you have juste to choise the global var needed, and Talend will give you the appropriate code. In this case, I want the CURRENT_FILEPATH : ((String)globalMap.get("tFileUnarchive_1_CURRENT_FILEPATH"))

It's really important to understand that if you want to use global var from component.

In your case, maybe you can rename your tFileList with a name variable more appropriate, like ListeFile

And then in your tMap try to write "ListeFile." and press "Ctr+Space"

Good luck

SGV

Re: How to insert tfilelist variable in table

Anonymous — Tue, 28 Nov 2017 13:13:57 GMT

@sgvThank you very much. I already made it but your answer made me understand a little more about those variables.