Hello there, I just got introduced to KNIME a couple of days ago and I am really in love with the software. I am now just trying to build my very first and own workflow. But I am facing some problems and I was hoping to find some guidance in the forum. Maybe someone has a good idea how to solve this issue. I do have a table. And I want the software to create several output files for me. I want to look up in a certain column how many different entries it has. And whenever the value changes I want to write a new output file. Let’s say. I have a column thats named “job number” and the number of rows with the same job number can vary. But whenever the next line with a new job number starts I want a new outout file to be written gathering all the entrys that belong to the same job number. And I want to do this for all the different job numbers. My problem is I never know how many different job numbers there are and the number of entrys vary. Otherwise I would have found a similiar forum entry. Unfortunately it does not work for me. Does someone have an idea which node I could use for this? Or maybe someone has read something similiar in the forum already? That both could be very helpful. I’d be very happy about every hint I could get :- ) Many thanks in advance already. Sarah

Hi @Sarah1989 That’s a job for the Group Loop node :slight_smile: Pro tip: have a look on the community hub. Whenever you look for a node there, you’ll find a section with example workflows that uses the node. [image] Group Loop Start Group loop start, each iteration processes another group of rows. The column(s) to group on need to be specified. The input data table is sorted based on the s… [image] For example: [image] Split a spreadsheet to different sheets – daria-tombolelli This workflow shows how to split an Excel spreadsheet into multiple sheets based on the unique values of a specific column. [image] use group loop to split tabe in several csv chunks – mlauber71 use group loop to split tabe in several csv chunks

Creating custom output-files considering the original data

KNIME Analytics Platform

mlauber71 October 10, 2023, 6:14pm 5

@Sarah1989 scheduling would be a KNIME Business Hub function. One thing I once built was this - more to demonstrate how it could be done then to actually use this in production: