topic Multiply/Duplicate row by given multiplier in Talend Studio

Multiply/Duplicate row by given multiplier

Anonymous — Mon, 17 Jun 2013 15:50:29 GMT

Hi,
is it possible to multiply/duplicate a row. It should be based on a given multiplier column (in the pic column "available_copies") without using a scripting component.

Re: Multiply/Duplicate row by given multiplier

alevy — Tue, 18 Jun 2013 00:17:09 GMT

Input --> tFlowToIterate -iterate-> tLoop -iterate-> tFixedFlowInput --> output.
Use the available_copies value as the To variable in tLoop.

Re: Multiply/Duplicate row by given multiplier

Anonymous — Wed, 19 Jun 2013 20:02:34 GMT

Input --> tFlowToIterate -iterate-> tLoop -iterate-> tFixedFlowInput --> output.
Use the available_copies value as the To variable in tLoop.

Hey,
is it possible that you explain it in more detail? What settings do i have to do in the components?
in tflowToIterate i used the available_copies as key_value
in tLoop i used the variable from tflowToIterate for my to value ((Integer)globalMap.get("avail_copies"))
but i don't know what i have to setup in tfixedFlowInput (makes no sense to me)

Re: Multiply/Duplicate row by given multiplier

alevy — Wed, 19 Jun 2013 23:54:55 GMT

tFixedFlowInput is used to make the output row, getting values from the input row that have been stored in the globalMap by tFlowToIterate.