Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Field (of the input) to use as parameter for the output

More
12 years 2 weeks ago #2216 by Gennaro
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 to join the conversation.

More
12 years 2 weeks ago #2217 by FlowHeater-Team
Hi Gennaro,

To set a parameter only on first row you have to use the following little script.
Code:
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 to join the conversation.

Time to create page: 0.273 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

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