Rule Based Row Filter (Dict)

[Suhas27]

Dear Knimers,

In Rule based row filter (dict), is there a possibility to identify for which rules the input table was filtered for.
Example - The bottom table contins the rules, the top table is filtered fpr the rules. The output is filtered tabel without any reference to Rules table.
But I want to capture the either the row ID from rules table or columns from rule tables.

Please share your findings and suggestions.

Thanks
Suhas

[elsamuel]

Welcome to the forum @Suhas27.

Off the top of my head, I’d suggest using a Rule Engine or Rule Engine (Dictionary) node to create the tags in the table to be filtered, then carrying out the filtering.

[ipazin]

Hello @Suhas27,

check bottom topic. You have example workflow in it.

rule based row filter parallel execution

Hi @izaychik63 @ipazin , Rule-based Row Filter (Dictionary) is doing the same thing in 1 minute for all 1 million records and 100 rules but now I am unable to map the rule_id with the filtered data.Is there any way to map rule_id with Rule-based Row Filter (Dictionary)? In my existing design I am mapping the rule_id as well with the help of constant value column by passing rule id as variable from Rule_sheet(Attached)rule_SHEET.xlsx (11.0 KB) . Attaching the Sample_input_data.SAMPLE_DATA.xl…

Br,
Ivan

[Suhas27]

Hi Ivan ,

Thanks for pointing me to this.
But I am still consfused regarding the config in Rule-based Row Filter node.
And I am not sure how to get row id details from rules table into the filtered table.

Will wait for your reference.

Regards
Suhas

[ipazin]

Hello @Suhas27,

not sure what your aim is exactly? If you use Rule-based Row Filter node the filtered table contains rows which did not match any rule so there should be any relation between rules and those rows. Can you maybe give us example on your input data together with rules and expected output?

Br,
Ivan