You need the
to grouping the CSV or Excel records. The problem is that usually the GroupBy Heater group’s data related to the content.
In your case you need the
.NET Script Heater
and a short C# Script to simulate the group value. Please have a look to the example I’ve attached. In the Script there is a remark were you can change how many rows are grouped together.
With this we can group always four CSV or Excel rows on the READ site to one record on the WRITE.
Now we just have to decide which row/content we have to move to the WRITE side. You need for each field one
together with one
to decide which grouped row you want to put to the WRITE.
NOTE: The IF-THEN-ELSE condition =1 means that the row content from the first are moved to the field, =2 ….
Attachment grouping_csv_records.zip not found
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.