Join two tables based on string columns

[knimediger]

Hello @carlos_amaya

First of all: Welcome to the world of KNIME.

For me the demonstrated example is not clear enough.
I assume that you are talking about the leading “0” in the credential.
If this is your challenge it might help if you spent one intermediate step to eliminate the “0” in this coulum and then apply the join.
To eliminate the leading “0” you may get some ideas from these topics

Removing all leading zeros from string

Hi everyone, i have 2 columns like that. Now i need to do delete all zeros at the beginning of string. Can you help me, pls ? [image] [Capture d’écran 2022-09-14 163107]

eliminate leading Zero-Values in a string column

Hello community, in my table I would like to eliminate the leading zero values ​​until the first numerical value or letter appears. [eleminate leading ZERO Values] eliminete leading ZERO Values.xlsx (13.3 KB) As a newbie, can you please help me with this (supposedly very simple) problem?

Removing leading characters

Hi, I am trying to remove leading zeros and leading spaces. For example: 000000123 000123002 ABC DG Expected Output: 123 123002 ABC DG Probably I need two nodes for zeros and spaces. Regarding zeros I tried string manipulation node but didn’t get it managed. Is there another node better?

If this does not help please give more details.