Rule Based Row Filtering to csv Loop

Hello! I am new to Knime and am wondering if there is a way to simplify this.

I have one large table and want to split it into 32 separate tables to export based on criterial listed in rows. Currently I have a manually created metanode to do this for me, but know there has to be a simpler way. I have been playing with the rule based row filter and loops but can’t seem to figure it out. In my head it should go something like “for i in xlist; apply rule based row filter and export.” But I cannot seem to find a way to do it with the nodes. I was looking at other examples but couldn’t find one that matched this scenario.

Here is the rule I used and and example of before and after the filter:
“($AwayTeam$ = “XXX” AND $Team$ = $HomeTeam$) OR ($HomeTeam$ = “XXX” AND $AwayTeam$ = $Team$) => TRUE”


I had “ANA” as “XXX” in the rule

Welcome to the forum @nfstatz.

You are right that this would be better implemented with a loop such as this:

image

Here’s the starting data:

And here are the automatically created output files:
image

The workflow is available here

4 Likes

Thank you so much! I look forward to trying this out and learning more about loop nodes and their capabilities. Much appreciated!

1 Like

Glad to help. Can you mark this as solved?

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.