CSV import duplicating records

Translated submission in the German forum. You can read the original entry here: CSV Import Datensätze kopieren

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

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 .