Icon

Challenge 16 - Grouping Data into CSV Files - Solution

Sales Group
100 b
200 a
300 a

You would generate two files: one named Group_a, and one named Group_b. They would have the following structure:

Sales Group
200 a
300 a

and

Sales Group
100 b

Your solution to this task should be generic — that is, it should work for any number of groups, and the names of the groups should not matter.

Challenge 16 - Grouping Data into CSV Files - SolutionYou were asked to split a single sales CSV file into smaller ones based on groups, named according to the group names. As an example, if the original file had the following data:Sales Group100 b200 a300 aYou would generate two files: one named Group_a, and one named Group_b. They would have the following structure:Sales Group200 a300 aandSales Group100 bYour solution to this task should be generic — that is, it should work for any number of groups, and the names of the groups should not matter.
Create relativepath location
String to Path (Variable)
Write smaller file
CSV Writer
Create filename
String Manipulation (Variable)
Read sales filewith groups
CSV Reader
Iterate over groups
Group Loop Start
Get group
Table Row to Variable
Variable Loop End

Nodes

Extensions

Links