Joiner, Row ID matches for 80%

Hey guys, is there a way to make the Joiner do partial matches?

I have one stream where it is "Image_123.JPG#1#1" and one where it is "Image_123.JPG". I was thinking about renaming them based on count, but not both streams of data contain all row's, so there is a large chance of wrong names being assigned.

Any easy trick to fix this?



Hi Luuk,

would it help to modify the entries of the first stream (the one with the "#1#1") to look like the entries of the other stream? You can try to use the `StringManipulation Node` and remove all characters starting at `#` (substring in combination with indexOf).

Does this help?