Talend community forum / new user - tcontextload not updating context variable

mvucovich · 2009-11-19 20:53:54

Hello,

I am using a context variable to dynamically update the output directory in a toutputfiledelimineted node. I am using tcontextload to update the context variable. I have the tables set correctly and the run window says:

tContextLoad set key employer_id with value 'C:\users\mvucovich\desktop\test_out.csv'

However the file is written to the path set as the default for that context variable, not the directory above. I'm quite confused because it appears that the context variable (employer_id) has been updated according to the log, but is not actually passing the value.

I am running Windows 7.

Thanks,

Michael

shong · 2009-11-20 04:53:34

Hello Michael
Can you upload some screenshots of your job?
You should load the value before other transcation, eg:
tFileInputDelimited_1---tContextLoad
|
onsubjobok
|
tFileInputDelimited_2----tFileOutputDelimited

Best regards

shong

mvucovich · 2009-11-23 18:13:30

Sure, see below. Thanks for the reply.

This is just a test job I am using to understand the functionality. The default context remains active even though the log pane says its been updated.

Thanks,

Michael

Uploaded Images

Last edited by mvucovich (2009-11-23 18:45:43)

shong · 2009-11-24 07:37:18

Hello

The default context remains active even though the log pane says its been updated.

The default value in context tab will never changed unless you change it manually, the value of context is changed at the runtime, if you print the context value on tPerlRow, you will see it output the new vlaue.

Best regards

shong

mvucovich · 2009-11-24 19:01:28

Thanks--

I'm confused--if tcontextload is saying that the context has been updated to reflect a new value (i use the print option), why would that value not be actually used in the toutputdeliminated node? I'm not trying to change the default value itself, I'm trying to use a different value in the job itself, dynamically set by the tcontextload node.

Could it be the case that context variables updated in the job do not apply to toutputdeliminated nodes?

The screenshots below are out of order (couldn't figure that out), but show:

the job execution--you can see that the default context contains a filepath that is different from the one updated by context load (in the run window).
the configuration of the toutputdeliminated node
the resulting file written to the desktop (which is not the name of the file in the updated context).

Uploaded Images

Last edited by mvucovich (2009-11-24 19:05:21)

shong · 2009-11-25 04:16:20

Hello
As I said before, you should load the value before other transcation, eg:
tFileInputDelimited_1---tContextLoad
|
onsubjobok
|
tFileInputDelimited_2----tFileOutputDelimited
why you still get the default value in your job? In the generated code, the file name is defined with default value before tFileIndelimited begin to works. You can read the wiki article and know the generated code model.

Best regards

shong

Announcement

Unanswered posts

#1 2009-11-19 20:53:54

new user - tcontextload not updating context variable

#2 2009-11-20 04:53:34

Re: new user - tcontextload not updating context variable

#3 2009-11-23 18:13:30

Re: new user - tcontextload not updating context variable

#4 2009-11-24 07:37:18

Re: new user - tcontextload not updating context variable

#5 2009-11-24 19:01:28

Re: new user - tcontextload not updating context variable

#6 2009-11-25 04:16:20

Re: new user - tcontextload not updating context variable

Board footer