Feature Request: More Powerfull Joiner

KNIME Analytics Platform
#1

Hi,

in my opinion it would be good to have a more powerfull Joiner node with the following features:

1) Currently it is only possible to choose between "Match all of the following" or "Match any of the following". It is not possible to do something combined like: 

A1 = A2 AND (B1=B2 OR C1=C2)

 

2) The following simple SQL query is hard to do in knime:

SELECT *

FROM Table1 a

JOIN

Table2 b

ON a.Field1 like Concat ('%',b.Field2,'%')

OR b.Field2 like Concat ('%',a.Field1,'%')

 

I know that there are some nodes to do similarity search, calculation of distances and subset match. But if I only want to join two tables on two fields where one is contained in the other (and vice versa) it becomes difficult with knime.

Thanks in advance

Regards

 

#2

Hi iiiaaa,

you could do this with two joiners and a concatenate node.

First joiner joins on A1 = A2 AND (B1=B2)

Second joiner joins on A1 = A2 AND (C1=C2)

Afterwards concatenate the two results and chose in the configuration dialog to skip rows for the duplicate row ID handling.

Best regards, Iris

#3

Hi Iris,

thank you very much! This is a good approach for the request number 1 even if a built in feature could help a lot in more complicated combinations.

May I ask you what you think about the second request?

Thanks

#4

Hi,

yes the second request is a open feature request. I added a +1.

I will keep you posted as soon as I have more news about it.

Best, Iris

#5

Thank you!

Regards

#6

Hi,

any news regarding this?

Thanks

Regards