topic Re: set a context variable and call it in next component in Talend Studio

set a context variable and call it in next component

Anonymous — Fri, 20 Apr 2018 07:55:00 GMT

Hi I need to assign a context variable while the job is running and use the same context variable in the subsequent component. ,

please check the below flow for what my requirement is , tfilelist is the first component

tfilelist--> tinputfiledelimited -->tjava --> tmysqloutput

can someone help me with how I shall proceed ,

Re: set a context variable and call it in next component

TRF — Fri, 20 Apr 2018 08:42:21 GMT

tJava component is executed 1rst and only once for the subjob, so tJavaRow is better in this case.

The question is, why do you want to use a context variable as soon as you have a standard global variable which contains what you want?

Re: set a context variable and call it in next component

Anonymous — Fri, 20 Apr 2018 08:53:03 GMT

being new to Talend, what i have understood is standard variable i.e. ((String)globalMap.get("tFileList_1_CURRENT_FILE")); will return me with the file name and extention. i.e if the file name is abc.txt it will return abc.txt, what i need is a table to be created with the name abc , not abc.tc , with the standard variable the table is getting created but with the name "abc.txt".

so i thought doing a substring on the name and storing that in a variable and later using that for table name

Re: set a context variable and call it in next component

TRF — Fri, 20 Apr 2018 09:00:49 GMT

You can make the substitution when needed or use tJavaRow in your case (because of tJava behaviour described previously)

Re: set a context variable and call it in next component

Anonymous — Tue, 24 Apr 2018 13:58:19 GMT

the substitution can be made as follows :

StringHandling.CHANGE(((String)globalMap.get("tFileList_1_CURRENT_FILE")),".txt","")

this worked for me as I directly put the above code in the table field.

reference on StringHandling Routines:

https://help.talend.com/reader/mhqCkTBnin7IXmJBUJoocQ/5qboCU~1NO4j7aF9JtCWNg