Rule Based Row Filtering to csv Loop

[nfstatz]

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

[elsamuel]

Welcome to the forum @nfstatz.

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

Here’s the starting data:

And here are the automatically created output files:

The workflow is available here

[nfstatz]

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

[elsamuel]

Glad to help. Can you mark this as solved?