Icon

KNIME_​challenge16_​solution

KNIME_challenge16_solution
Challenge 16: Grouping Data into CSV FilesLevel: EasyDescription: 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:....Your 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.Author: Victor Palacios Access the data directly from the knimehubhttps://hub.knime.com/ Loop over group, define relative filepath and save csv's (overwrite if needed) Group_a.csv aGroup_b.csv bGroup_c.csv cGroup_d.csv dGroup_e.csv eGroup_f.csv fGroup_g.csv gGroup_h.csv hGroup_i.csv iGroup_j.csv jGroup_k.csv kGroup_l.csv lGroup_m.csv mGroup_n.csv nGroup_o.csv oGroup_p.csv pGroup_q.csv qGroup_r.csv rGroup_s.csv sGroup_t.csv tGroup_u.csv uGroup_v.csv vGroup_w.csv wGroup_x.csv xGroup_y.csv yGroup_z.csv z synthetic_datasetgrouped_sales_data.csvknime huburlLoop on GroupNode 27Node 28Node 29Loop end CSV Reader HTTP(S) Connector Group Loop Start CSV Writer VariableExpressions String to Path(Variable) Variable Loop End Challenge 16: Grouping Data into CSV FilesLevel: EasyDescription: 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:....Your 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.Author: Victor Palacios Access the data directly from the knimehubhttps://hub.knime.com/ Loop over group, define relative filepath and save csv's (overwrite if needed) Group_a.csv aGroup_b.csv bGroup_c.csv cGroup_d.csv dGroup_e.csv eGroup_f.csv fGroup_g.csv gGroup_h.csv hGroup_i.csv iGroup_j.csv jGroup_k.csv kGroup_l.csv lGroup_m.csv mGroup_n.csv nGroup_o.csv oGroup_p.csv pGroup_q.csv qGroup_r.csv rGroup_s.csv sGroup_t.csv tGroup_u.csv uGroup_v.csv vGroup_w.csv wGroup_x.csv xGroup_y.csv yGroup_z.csv z synthetic_datasetgrouped_sales_data.csvknime huburlLoop on GroupNode 27Node 28Node 29Loop end CSV Reader HTTP(S) Connector Group Loop Start CSV Writer VariableExpressions String to Path(Variable) 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: MMU
Created at: 2022-05-16
On NodePit since: 2022-05-16
Last update: 2024-04-27
Created with KNIME version: v4.5.2
Tags: justknimeit-16justknimeit

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

Try NodePit Runner!