topic Re: Creating global variable from external file in Talend Studio

Creating global variable from external file

Anonymous — Wed, 09 Jan 2019 06:30:43 GMT

Hi All,

I am new to talend. I am trying to find out the way to create global variables automatically from the external file.

If anyone has already faced this scenario.

Re: Creating global variable from external file

TRF — Wed, 09 Jan 2019 07:31:17 GMT

Suppose you have a CSV file with fields key and value. Connect a tFileInputDelimited to a tSetGlobalVar. Add Aline into the variable array and enter row1.key for the key field and row1.value for the value.
When you will run that job, you have 1 variable for each input file record.

Re: Creating global variable from external file

Anonymous — Wed, 09 Jan 2019 07:36:42 GMT

Hello,

Could you please let us know if this scenario helps?

TalendHelpCenter:Reading data from different MySQL databases using dynamically loaded connection parameters

Best regards

Sabrina

Re: Creating global variable from external file

Anonymous — Wed, 09 Jan 2019 08:04:40 GMT

Hi Sabrina , Thanks for your quick reply. I went through the link but there contextload is being used to export the variable but in my case I am not able to use contextload because I am not able to access context varibale in RUN IF trigger link, but global variables are accessible there, so I am going with global variables.

Re: Creating global variable from external file

TRF — Wed, 09 Jan 2019 08:14:39 GMT

tContextLoad should work if you want to load context variables - don't know why you can't use a context variable in a If trigger expression.

However, as you were asking for a solution for global variables, my previous answer should help you.

Re: Creating global variable from external file

martel — Wed, 09 Jan 2019 08:30:43 GMT

i have a job todo this , and run prejob on all job for initialization (cf screens)
2019-01-09_09-28-24.jpg
2019-01-09_09-27-37.jpg
2019-01-09_09-26-33.jpg

Re: Creating global variable from external file

Anonymous — Wed, 09 Jan 2019 10:08:36 GMT

Thanks All for the help, TRF's solution worked out as I am using global variable. I will explore contextload as well, why I am not able to access context variable in run if trigger.