Near match function in Rule Based Node

Dear Group,

I have two columns i.e. A & B and some information is matching in each column but it is not exactly the same. I need function for near matches to apply in rule based node
e.g. I need alternate of $ColumnA$ MATCHES $ ColumnB$ => TRUE base on near matches

Well, depending on how strict you want to be you could try the LIKE function.

Alternately, you might need to move outside the Rule Engine node and try some fuzzy matching. Here’s an example workflow to give you an idea - it requires a dictionary of “correct” matches.

1 Like