FlowHeater - The Data Import / Export Specialist
See also the existing examples of using the TextFile Adapter , which may answer your question: text file codepage converting 1 / 2 , processing of CSV header and footer rows , Import/Export vCard (line based) text files

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

  • Gennaro
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
10 years 10 months ago #2215 by Gennaro
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?


Please Log in or Create an account to join the conversation.

10 years 10 months ago #2218 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:Add a record to each record of the 'write' side
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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.285 seconds

other Languages


FlowHeater Home

de en


Privacy Statement

Copyright © 2009-2023 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook


 de en