My mystake or bug with Joiner?

Paolodam · October 31, 2020, 3:53pm

Hi,
I’m facing what I’m sure is a simple problem but I can’t find the mistake.
I have two tables that I have simplified just to show my problem in the attached example.
Both table have two columns one with a string and one with an integer.
If I match them in excel using the string a get a full corrispondance (they are identical). In Knime it seems that those two strings below are not identical:
Left table: C - Certificazioni e Progetti/01.Impianti elettrici/01.[AAAA].Apertura/01.Progetto Esecutivo Firmato/
Right table: C - Certificazioni e progetti/01.Impianti elettrici/01.[AAAA].Apertura/01.Progetto Esecutivo Firmato/

I attache the Knime workflow example and the excel where you see they fully match.
What am I doing wrong?

Example.xlsx (11.1 KB) Example.knwf (24.7 KB)

Mohammad_Nazemi · October 31, 2020, 4:26pm

Hi, Can you show your joiner config ?

Paolodam · October 31, 2020, 4:59pm

Hello Mohammad, I’ve attached the knwf file. There you can open the joiner node

Mohammad_Nazemi · October 31, 2020, 5:06pm

yes.I find them.
you just have a little mistake they did not match because of difference in writing. one have P another was p

Paolodam · October 31, 2020, 5:26pm

You are right!!! Thank you Then is excel who is wrong. Nevermind excel

system · November 7, 2020, 5:26pm

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