Joiner with wildcards

Hi KNIME community !

I’m trying to use a joiner with wildcards in my mapping table.

Basically, I have an extract (P&L) and I would like to categorize each line thanks to criteria in several columns. I have a mapping table but I would like to use wildcards for some criteria like begins with « Accrual » —> « Accrual* »
Or just « any value » —> « * ».

Is there a way to do that with knime?

Thanks a lot !

1 Like

What about using regex to first extract the pattern you are searching and store that in a column and do the join based on that column afterwards?


Hi @chouadrien and welcome to the forum.

Sounds like the Column Expressions node might be useful here. Check this topic for examples of using conditional statements within it to do some labeling:

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.