Joiner with wildcards

[chouadrien]

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 !

[Daniel_Weikert]

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?

[ScottF]

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:

How to use if expressions in a column expressions node

@gwhall6 thank you for the insight. I too am converting from Alteryx to KNIME but do not have a deep coding background. I absolutely love the Formula tool in Alteryx for its power and ease of use. What is the KNIME equivalent and how does one go about writing ElseIF statements, IF statements etc? As a note - I found the Column Expressions node and would like to know how we might write an IF statement in it.