Join us, today at 10:00 AM ET, for an introduction to the new Dataiku Academy Learn more

Left join with empty values as one of the keys

Level 1
Left join with empty values as one of the keys

Hi,

I have difficulties to make a left join with multiple columns as keys.
One of the columns can have empty cells (null) and it seems that the join is considering that no value can be found with the join.
For example :
Key : Columns 1 , 2 and 3.

left table : A B C D
D E Null F

on the right table:
A B C G
D E Null H

result :
A B C D G
D E Null F Null

So Dataiku seems to not recognize an empty value as a valid key and so it is removing the values.

Is there a way to avoid this problem ?

Thanks !

0 Kudos
1 Reply
Dataiker
Dataiker

Jack,

What recipe engine are you using?

GCase_0-1579515453672.png

Also

 

LEFT Table  
    
Col 1Col 2Col 3Col 4
ABCD
DENULLF
    
    
RIGHT Table  
Col 1Col 2Col 3Col 4
ABCG
DENULLH

 

Also, are these representations of the table you are trying to get results from?

0 Kudos