cross two database

#1

Hello everyone,
I have two DBs and I need to cross them, but I need to be left with a new column that shows those that crossed with a 1 and those that did not with 0.

Column 1
1234
2344
456

Column2
0
1
0

thanks

#2

Use Cross Joiner and when Rule Engine to add 0/1.

2 Likes
#3

I don´t understand, i new in this knime, can show an example with the nodos pls?

thanks

#4

Hi there @cmunoq,

you have 2 tables in database and you need to see where they match? And then in one of them add new column with 1 if value matches value in second table, else 0?

Br,
Ivan

1 Like
#5

yes sir, in a column that shows me those who crossed with 1 and those who did not cross with 0

#6

Hi @cmunoq,

if so you can use DB Joiner node (or Joiner if data in KNIME) to join tables with Left Outer Join (connect table where you want your identifier to upper Joiner port in this case) as join mode and don’t remove joining columns. Then use Rule Engine to add 0 if missing value is in joining column of second table else 1.

Give it a try and if any questions feel free to ask. Also if necessary I can share workflow example :wink:

Br,
Ivan

3 Likes
#7

hi @ipazina what a shame I could not, although the crossing is not with BD it is with excel reader xls document. Try joiner but it only brings me the ones you cross. Could you share an example please, I would really appreciate it