Update Table for each successful tFTPGet

[PhilipSommer]

I have a requirement to move files listed in an AS400 table to the local disc, delete the file from the remote location and then update the row for the file in said table. My current setup in Talend Enterprise Data Integration Studio (v5.4) looks like this:

1. Connect to DB

2. Connect to FTP

3. Read all relevant rows. These contain the files' location on the FTP remote

4. Build a falid filepath from the data fields

5. Iterate over the rowset

6. Check if the file exists

7. If it does, get it

8. Then delete it

9. Update a row flag in the DB

Step nine is where I'm having trouble, because the data flow from the original tMap is no longer available and if I drag a new row output from the tMap then the DB Output Component becomes part of the subjob that executes way before the file is actually confirmed to be retrieved. How can I access the data flow from the beginning of the process and only do so after the FTP file is read?

Thanks for any help in advance.

-Philip

[manodwhb]

@PhilipSommer ,you can take on Component Ok from tFTPGet to tAs400Output.

[PhilipSommer]

The tAS400Output neither accepts the On Component OK or On Subjob OK triggers from the tFTPGet.

[manodwhb · Accepted solution]

@PhilipSommer , why cannot you use tAs400Row instead of tAS400Output? you can take On Component Ok from tFTPget to tAs400Row ?

[PhilipSommer]

Thanks, that worked, although I now have to concatenate a SQL String from the fields put in the globalMap by the tFlowToIterate.