Using flow variable in rule-based filter

I expected this to work with a string array as argument for the IN operator, but the Rule-Based Row Filter doesn’t accept string array variables as input. Strange.

If only exact matches are desired, a Reference Row Filter will work as well. Simply transform the input string into a column instead. The Cell Splitter insists on changing the type to double, so we need to manually cast back to a formatted string with a Java Snippet (number to string insists on using floating point).

//the zero forces zero digits after the decimal point, so it's a normal "integer"
out_values = String.format("%.0f", c_values);


flow variable in rule-based filter.knwf (36.6 KB)

2 Likes