I am new to Knime. I have a table with several categories, and I want to separate the rows based on the columns’ unique values. I’ve already done it with the “RoW Filter” node, but because the number of unique values in that column exceeds 200, it’s inefficient.
Are there more efficient ways to filter rows without using 200 row filter nodes?
I also need to connect it to the python script after filtering the rows. The script creates two JSON outcome files. I removed python output port and saved the json files on my laptop and then used the “read JSON” node to upload the files; is there any way to define the output of the Python script as a JSON and then connect it to another node?
My file is very big and I was thinking if I could separate rows based on their categories and save them separately in several tables so I could later apply my transformation to them.
I defined several paths to store them, but I’m not sure how I can use write to CSV before group loop end because I don’t have an output port. Do you have any suggestions? 2018 Manhttan.knwf (27.4 KB)
I need to write the groups in different folders, I have already created several paths, but I am not sure how I should use “write to CSV” before the loop end. Do you suggest any nodes for this purpose as well?