Hi,
I have two database reader nodes that produce two outputs.
1st DB reader output:
Partner_id Partner_name 123 abc 456 def 789 ghi
2nd DB reader output:
VIN Partner_id 56788990 123 4547y575 6765859t 123
Desired output:
> VIN Partner_id Partner_name
> 56788990 123 abc
> 4547y575
> 6765859t 123 abc
Doing this in SQL is not an option due to lack of common indexed primary key in both tables.
Is there a node I could use to achieve this?
I tried the Joiner node (joined on partner_id) but i got this
> VIN Partner_id Partner_name
> 56788990 123 abc
> 4547y575 123 abc
> 6765859t 123 abc
Notice that for VIN ending with 575 there should be no partner_id or partner_name