Dynamic data import / export


simply more productive
Up to 10,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.

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

Add a record to each record of the 'write' side 4 years 8 months ago #2215

  • Gennaro
  • Gennaro's Avatar
  • Offline
  • Junior Member
  • Posts: 25
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:

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:

2999 ABC BDE

So, I wuould get an ouput file or table like:

is there a way to make it with flowheater?

The administrator has disabled public write access.

Re:Add a record to each record of the 'write' side 4 years 8 months ago #2218

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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.

Attachment groupout_copy_input_rows.zip not found

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.072 seconds