Joiner with wildcards

[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.