Dynamic data import / export

datenbank

simply more productive
Up to 100,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.
  • Page:
  • 1

TOPIC: Can FH change codes per logic

Can FH change codes per logic 7 months 2 weeks ago #2810

  • Andrew Wojciak
  • Andrew Wojciak's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 21
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 or Create an account to join the conversation.

Can FH change codes per logic 7 months 2 weeks ago #2811

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 254
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-column-multiple-condition.zip
File Size: 2 KB
Attachments:

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

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.

Can FH change codes per logic 7 months 2 weeks ago #2814

  • Andrew Wojciak
  • Andrew Wojciak's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • Posts: 21
Very quick and comprehensive response. Thank you Robert.

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

  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.137 seconds