Dynamic data import / export

datenbank

simply more productive
Up to 10,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.

TOPIC: Can FH change codes per logic

Can FH change codes per logic 3 months 3 weeks ago #2810

  • Andrew Wojciak
  • Andrew Wojciak's Avatar
  • Offline
  • 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:
The administrator has disabled public write access.

Can FH change codes per logic 3 months 3 weeks ago #2811

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
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.
The administrator has disabled public write access.

Can FH change codes per logic 3 months 3 weeks ago #2814

  • Andrew Wojciak
  • Andrew Wojciak's Avatar
  • Offline
  • Junior Member
  • Posts: 21
Very quick and comprehensive response. Thank you Robert.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.077 seconds