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: CSV import duplicating records

CSV import duplicating records 6 years 1 month ago #2065

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Translated submission in the German forum. You can read the original entry here.

Hi,

Can I make two CSV records out of one? The imported CSV record is an entry with a counter entry. I need an exported record where the entry and counter entry appear as two different records.

Greetings
M. Leipfinger
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.

Re:CSV import duplicating records 6 years 1 month ago #2066

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi Mr Leipfinger,

You can achieve this with the GroupOut Heater. The GroupOut Heater clones per imported record 1-n identical copies. In order to output some of the columns of the copied row as different values on the WRITE side you also need to use the IF-THEN-ELSE Heater together with the AutoID Heater. I have written a brief example for you, see the attachment.

Note that the AutoID Heater is specifically used for records/rows that belong together. In this way you can determine the output for specific columns of the cloned rows by testing the IF-THEN-ELSE condition = 1 or = 2.

If more than one copy is generated this way, then using this method with a series of IF-THEN-ELSE Heaters rapidly becomes cumbersome. In extreme cases you can fallback on the .NET Script Heater. Here I also give a brief IF-THEN-ELSEIF example.

Attachment GroupOut.zip not found

Attachments:
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.
Moderators: FlowHeater-Team
Time to create page: 0.072 seconds