Icon

Challenge 16 - Grouping Data into CSV Files

Challenge 16 - Grouping Data into CSV Files
Challenge 16: Grouping Data into CSV Files Description: You were asked to split a single sales CSV file into smaller ones based on groups, named according to the groupnames. 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 groupsshould not matter. READ DATA LOOP THROUGH EACH GROUP, CREATE RELATIVE PATH AND FILE Read sales_dataLoopby GroupSortby GroupFilenameto variableCreatefilenameCreaterelative pathWrite fileNode 9CSV Reader Group Loop Start Sorter Table Rowto Variable String Manipulation String to Path(Variable) Excel Writer Variable Loop End Challenge 16: Grouping Data into CSV Files Description: You were asked to split a single sales CSV file into smaller ones based on groups, named according to the groupnames. 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 groupsshould not matter. READ DATA LOOP THROUGH EACH GROUP, CREATE RELATIVE PATH AND FILE Read sales_dataLoopby GroupSortby GroupFilenameto variableCreatefilenameCreaterelative pathWrite fileNode 9CSV Reader Group Loop Start Sorter Table Rowto Variable String Manipulation String to Path(Variable) Excel Writer Variable Loop End

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: USER
Created at: 2022-08-24
On NodePit since: 2022-08-30
Last update: 2024-11-18
Created with KNIME version: v4.5.0
Tags: justknimeit-16

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!