spliting data

Hey, I was trying to filter data by “Login” , then divide by occurances and save separately as excel file so specific number of rows be in them. I have tried Group Loop but I do not know how to split them by certain number. I want to use each row only once.

I have included the example of table and prt sc of my workflow.

Can somebody help me ?

dane 1.xlsx (8.5 KB)

image

Use pivot-table in Excel. Why KNIME?

Hi @89trunks -

I took a look at your input spreadsheet, but I’m still not sure what you’re trying to do. Could you post an example of what your desired output would look like? Maybe even export the workflow itself, if there’s not a concern about confidential data.

I think like thisdane 1.xlsx (14.3 KB)