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

Can FH change codes per logic

  • Andrew Wojciak
  • Topic Author
  • Offline
  • User
  • User
More
7 years 7 months ago #2810 by Andrew Wojciak
Can FH change codes per logic was created by Andrew Wojciak
Can FH do this? If yes, how?
• Read site: .TXT file, example ‘DTNA_FORECAST_20160803AWsample.txt’, is attached.
• On the Write side same .TXT file but AL53 codes in the 2nd column should be changed per logic: If AL53 in the 2nd column AND (013 or 058 or 065) in the 3rd column THAN change AL53 to AL53X [or append X].
When designed correctly change from AL53 to AL53X should be done only in the top three rows of the sample file.
Thank you for assistance,
Andrew
Attachments:

Please Log in to join the conversation.

More
7 years 7 months ago #2811 by FlowHeater-Team
Replied by FlowHeater-Team on topic Can FH change codes per logic
Hi Andrew,

Of course, that´s the power of FlowHeater :-)

I’ve made as short example for you, please have a look to the attachment.

Example description
First you need one String Append Heater to create the check condition for the IF-THEN-ELSE Heater . The String Append Heater combines the second and the third column with “#” as delimiter, for example “AL53#013”. The output can now be checked in the If-THEN-ELSE Heater . In your case you need three “or” conditions like the screenshot below.

Is this the cases (second input) you need one more String Append Heater to add the X at the end of the field content. Otherwise (else, third input) you have to put the second column directly without changes to the IF-THEN-ELSE Heater .



File Attachment:

File Name: change-col...tion.zip
File Size:2 KB

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.

  • Andrew Wojciak
  • Topic Author
  • Offline
  • User
  • User
More
7 years 7 months ago #2814 by Andrew Wojciak
Replied by Andrew Wojciak on topic Can FH change codes per logic
Very quick and comprehensive response. Thank you Robert.

Please Log in to join the conversation.

Time to create page: 0.336 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.