tIteratetoFlow - how to convert back from Iterate to Flow

Five Stars

tIteratetoFlow - how to convert back from Iterate to Flow

I have an iterate section in my job, but cannot connect it back to flow to write all the results into a database. (as iterate would write one by one). My last task in the iterate chain is a replace, but I cannot connect it back to titeratetoFlow. Why? What shall I use?

 

TExcelInput -> Tmap -> TFlowtoIterate -> ....   TRESTCLient, -> XMLfieldextract. -> Treplace   and then I cannot connect back here to TIteratetoFlow->MSSQL

 

TiteratetoFlow does not accept the connection row from Treplace.

 

What connector shall I use?

Ten Stars

Re: tIteratetoFlow - how to convert back from Iterate to Flow

tIterateToFlow requires an incoming Iterate link and produces an outgoing flow link.  You are trying to connect a flow link from tReplace.  

 

If your intention is to accumulate values in the iteration, you should direct the flow from tReplace to an output component. If you don't want to output directly to your database, you can use a tHashOutput as temporary storage and write out the entire contents of the hash after your iterations are complete.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download