With the freeware Version up to 100.000 recordscan be processed!
FlowHeater - The Data Import / Export Specialist
DOWNLOADFreeware Version (10 MB)- No registration required -
 
Welcome, Guest
Username: Password: Remember me
Forgot your password? Forgot your username? Create an account
Support Forum
General
Field (of the input) to use as parameter for the output
See also the general examples available, which may answer your question: Hello World 1 / 2 / 3 , format numbers as character strings , simple If-Then-Else , complex If-Then-ElseIf , filtering and grouping data , consolidate grouped values
  • Page:
  • 1

TOPIC:

Field (of the input) to use as parameter for the output 10 years 3 months ago #2216

  • Gennaro
  • Gennaro's Avatar Topic Author
  • Offline
  • Posts: 27
Hi (again),
I'm trying to use a field (which is present once in the read side) as parameter to be saved on each record of the write side.

I'm trying the GET/SET parameter with no luck...

any suggestions?


thanks again


P.S. please see the example attached, I'd like to replicate the field 'notes' of the read side to each row of the write side.

Attachment example.zip not found

Attachments:

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

Re:Field (of the input) to use as parameter for the output 10 years 3 months ago #2217

Hi Gennaro,

To set a parameter only on first row you have to use the following little script.
int count = 0;

public object DoWork()
{
  if (InValues.Length == 0)
    throw new Exception("one input parameter expected");


  // only set the parameter on first row
  if (count == 0)
    Parameter.SetValue("first_number", InValues[0].GetValue());

  count++;

  return null;
}

Note: In the .NET Script Heater you have to switch the "Execute when" option to "Per each Row"

In the attachment you can find a brief example how to use it.

In one of a next version I’ll put this feature into the Set Parameter Heater, thanks for the request.

Attachment set_parameter_only_on_first_row.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.
Attachments:

Please Log in or Create an account to join the conversation.
  • Page:
  • 1
Support Forum
General
Field (of the input) to use as parameter for the output
Time to create page: 0.099 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en