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

CSV import duplicating records

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
13 years 4 months ago - 4 months 2 weeks ago #2065 by FlowHeater-Team
CSV import duplicating records was created by FlowHeater-Team
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.
Last edit: 4 months 2 weeks ago by FlowHeater-Team.

Please Log in to join the conversation.

  • FlowHeater-Team
  • Topic Author
  • Offline
  • Admin
  • Admin
More
13 years 4 months ago #2066 by FlowHeater-Team
Replied by FlowHeater-Team on topic Re:CSV import duplicating records
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


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.337 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.