Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
sbxr
Contributor III
Contributor III

Multiple file schema check and then copy

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 

Labels (1)
  • v7.x

1 Reply
Anonymous
Not applicable

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