Splitting CSV into multiple CSVs by unique combination of two columns
Hi, I’m new to KNIME and was hoping to build this with some information online but I am need of a little help!
I’d like to separate a CSV file into multiple CSVs based on a the combination of perils and regions.
For example, I have columns Loss, Peril, Region and I’d like to split the CSV into 4 files (US windstorm, EU windstorm, US earthquake and US fire).
My current workflow looks like this:
My idea was to do the following but haven’t correctly created it in practice:
Read in CSV
Group by Region, Peril
Group Loop Start (filtered by Region and Peril)
CSV writer - was hoping to dynamically create file names and export
End Loop