Hi Guys,

I have a directory with many files, each file have Header and Detail. I need to read Header into Header table, then combine Header and Detail into Detail table. I tried the following steps:

1. create a job(job1) to separate the file to two temporary file (use tCreateTemporaryFile), one for Header File, the other for Detail file
2. create a job(job2) : tRunJob(job1)->onsubjobok --> tInputFile for Header,  use tMap to ouput to database
                                and the other tInputFile for Detail, then lookup to tMap to combine them together
3, create a job(job3): use tFilelist->iterate -->trunjob(job2)

when I run the job3, it shows tFilelist 3 execs, but in database, only the last file data was treated. Please help!!

Last edited by edwin.wang@oasolutions.ca (2010-08-27 02:20:46)