You are not logged in.
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!!