topic Execute job based on file name in Talend Studio

Execute job based on file name

Anonymous — Wed, 04 Jul 2018 21:50:55 GMT

I am looking to automate some processes based on a files name. I have several jobs set up to execute on files within the same files. If I have a file names foo*.xls, I would like to run job fooManipulate. If the filename is bar*.xls, I am looking to run job barManipulate and so on and so forth. Is there a way to automate the process so that it iterates through each file in the folder and runs the correct job?

Re: Execute job based on file name

Anonymous — Thu, 05 Jul 2018 04:46:26 GMT

Not exactly sure of your flow but have you tried tRunJob?

Re: Execute job based on file name

Jesperrekuh — Thu, 05 Jul 2018 11:22:58 GMT

The tRunJob has an option: dynamic job , you can use a context/global variable which you set runtime while using the tFileList to check for files.

Re: Execute job based on file name

Anonymous — Thu, 05 Jul 2018 13:18:13 GMT

You can always create a dynamic instance with context or globalMap

Re: Execute job based on file name

fdenis — Thu, 05 Jul 2018 13:29:58 GMT

are you running on TAC or on a standalone jobs?

Re: Execute job based on file name

fdenis — Thu, 05 Jul 2018 13:37:34 GMT

on TAC Talend Administrtor Center you can add file triggers with mask to run your Job.

on Standalone add new job with tFileList with mask linked by iterationLink to the coresonding tRunJob. do not forget to set subjob context using globaMal("tFileList_x_CURRENTFILE").
good luck.