Split data into separate Excel with one column, then to separate sheet with another column?

Can you upload a portion of the data for us to work with?

I’d recommend taking a look at the Solutions to Just Knime It Challenge 2 for some pointers. The challenge was to split a CSV file into several different CSV files and store them in different folders.

The thread is here. My solution is here

Your problem is similar. You’d need to use flow variables to control tab creation.

2 Likes