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