Join two tables based on string columns

[carlos_amaya]

Hello all!!

I’m trying to join two tables, based on string columns, but some times there a situation like the one shown below; since it’s not possible to add validations within the join node, hope you can help me get a solution for this, I was thinking on using Credential.Contains(Tag) or Tag.Contains(Credential) as a validation to join both tables, but not sure which node could help me do something like that.

Table A
Name Pet Tag
Haru Cat 593801A

Table B
Location Credential
US 000593801A

Result
Name Pet Tag Location Credential
Haru Cat 593801A US 000593801A

Thanks in advance!

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

[carlos_amaya]

Thank you for your shift response @knimediger, so far this helped me moved forward with my solution!!

Best regards!!