tFlowToIterate: How to transport Input Rows to tFixedFlowInput effectively

Teguard_Dev — Tue, 06 Oct 2020 08:08:35 GMT

Hello,

I'm trying to figure out how to transport data / input rows going into a tFlowToIterate effectively to the tFixedFlowInput.

Is this only possible via a context variable or globalMap ?

A bit of context:

I'm retrieving data from SAP via tSAPTableInput, so I'm getting for example 200-500 inputs, but I need them to later go into separate output files (that's the reason why I'm using the tFlowToIterate).

My Example Job currently looks like this.

The real question is now the following:

Is it reliable to have a tjavaRow in front of the tFlowToIterate that writes the current input into globalMap or context-variable?

Or is there a better solution for this?

Re: tFlowToIterate: How to transport Input Rows to tFixedFlowInput effectively

pakapi_ — Tue, 06 Oct 2020 18:38:32 GMT

Hi Teguard_Dev,

Do you have any dynamic filename part implemented to prevent overwrite the same file?

There is no need to save flow to globalMap. You can usetFlowToIterate variables. Look at the example. tSleep is only for guarante a uniqueness of a filename, which is: "D:/out/SAMPLE"+TalendDate.formatDate("yyyyMMddHHmmssSSS",TalendDate.getCurrentDate())+".csv" 😉

topic Re: tFlowToIterate: How to transport Input Rows to tFixedFlowInput effectively in Talend Studio

tFlowToIterate: How to transport Input Rows to tFixedFlowInput effectively

Re: tFlowToIterate: How to transport Input Rows to tFixedFlowInput effectively