topic Re: assign context with filename which has a timestamp in Talend Studio

assign context with filename which has a timestamp

BeginnerNeedsHelpPlease — Fri, 15 Nov 2024 21:45:52 GMT

Hello

I have the parent job below which has 2 simple child jobs (see 1st pic).

The first child job read a file in an INPUT folder, makes some transformtions and store the new file in a TEMP folder.

I have context variables to define my folders (see 2nd pic)

this new file in the TEMP FOLDER is named with a timestamp (see 3rd pic)

The second child job reads the temporay file (with the timestamp), makes some transformations and store this final file in a FINAL folder.

I have context variables to define my folders (see 4th pic)

But I have trouble with the second child job when I want to find the temp file with the timestamp (see 5th pic)

I don't how I can find the file with the timestamp. (actually, if I don't use a timestamp in the 1st child job, I can make it works but I need to use a timestamp)

Can you help me?

Re: assign context with filename which has a timestamp

anselmopeixoto — Fri, 26 May 2023 12:33:33 GMT

Hello @adi nul

Try defining a variable on your parent job to store the timestamp the same way you did on tFileOutputExcel.

Then transfer this same variable to both your child jobs as a context parameter. You can set the subjob parameters on tRunJob component.

This way, the variable will have the same timestamp value along the execution of your job.

Re: assign context with filename which has a timestamp

BeginnerNeedsHelpPlease — Fri, 26 May 2023 17:09:27 GMT

thank you