TOPIC: Add a record to each record of the 'write' side

hi,
i'd need to add the same record to each record on the wite side.

for example, on the read side i have the following data:

code amount date
2333 23,3 2011
2333 22,3 2010
2300 28,4 2011
2300 25,3 2011
2300 20,8 2010
2333 22,0 2011

the (fixed) record to add on the wite side is:

code company notes
2999 abc bde

so, i wuould get an ouput file or table like:




is there a way to make it with flowheater?

thanks!

Hi Gennaro,

To make copies from some rows you have to use the GroupOut Heater. Furthermore you need for each field one IF-THEN-ELSE Heater to decide which content you want to move to the WRITE side.

I guess in your case you want only copy rows per each group (CODE Field)? For this you need a little script to do this. The script decides on the CODE Field if the GroupOut Heater has to copy this row.

Then you need one AutoID Heater with activated GroupOut option for the IF-THEN-ELSE Heater condition. The AutoID Heater counts from 1 to … for each (copied) group.
If the AutoID Heater returns 1 the static header line is presented otherwise the data from the (CSV) text file are presented.

Please have a look to the brief example in the attachment.