See attached workflow and try to adapt it for yourself in the following way:
Copy/Paste joining strings into column1 and column2 and compare them with “String Manipulation” node.
If return value is 0 (column “compare”), both strings are exactly the same and there should not be any problem with join. If return value differs from 0, try to manually identify possible differences like trailing space, etc.
Compare_Strings.knwf (3.3 KB)
The apostrophe character in the joining does not cause a problem when joining strings, unless the apostrophe characters are different ( ` or ’ ). You can also try the option suggested by Martin_K and find out if the strings are identical.
Hi @TIZIZ -
You can use the Column Aggregator or Math Formula nodes to sum column values.
Use “GroupBy” node with “Sum” aggregation method (include all columns you want to be sumed) or you might also use (if applicable) “Pivoting” node, you will find sum of rows per each column on “Pivot Totals” output port.