topic Multiple file schema check and then copy in Talend Studio

Multiple file schema check and then copy

sbxr — Thu, 07 Nov 2019 08:32:41 GMT

Hi,

I have multiple file to check schema which i can do using tfilelist and global variable to read file,

But now what i want is if i have seven files and six files pass the schema check and one got failed ,

In order 2 of tfilelist it should copy only 6 files leaving the one which doesnt pass.

How to achieve this scenario.please help

Regards.

FYI @nthampi @shong

Re: Multiple file schema check and then copy

Anonymous — Fri, 08 Nov 2019 00:07:25 GMT

Hi
You need to design the jobs as below:
parent job:
tfilelist--iterate--tRunjob
on tRunJob, call the child job, pass the current file path to child job, uncheck the 'die on error' option.
Please refer to this documentation to learn how to pass the current file path to child job.
https://help.talend.com/reader/rPqHEobxhKnLJRLBS~_unw/HnnnoNuTa5UDsLG47_PAPQ

child job:
read current file-->check schema
|onsubjobok
move the file to target folder.

Hope it helps you!.

Regard
Shong