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?
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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Practical steps to developing your data integration strategy.