topic Re: Left join with empty values as one of the keys in Using Dataiku DSS
https://community.dataiku.com/t5/Using-Dataiku-DSS/Left-join-with-empty-values-as-one-of-the-keys/m-p/4250#M3001
<P>Jack,</P><P>What recipe engine are you using?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="GCase_0-1579515453672.png" style="width: 400px;"><img src="https://community.dataiku.com/t5/image/serverpage/image-id/313i8EB0CFBC833D64EB/image-size/medium?v=1.0&px=400" title="GCase_0-1579515453672.png" alt="GCase_0-1579515453672.png" /></span></P><P>Also</P><P> </P><TABLE width="256"><TBODY><TR><TD>LEFT Table</TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Col 1</TD><TD>Col 2</TD><TD>Col 3</TD><TD>Col 4</TD></TR><TR><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD></TR><TR><TD>D</TD><TD>E</TD><TD><EM>NULL</EM></TD><TD>F</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>RIGHT Table</TD><TD> </TD><TD> </TD></TR><TR><TD>Col 1</TD><TD>Col 2</TD><TD>Col 3</TD><TD>Col 4</TD></TR><TR><TD>A</TD><TD>B</TD><TD>C</TD><TD>G</TD></TR><TR><TD>D</TD><TD>E</TD><TD><EM>NULL</EM></TD><TD>H</TD></TR></TBODY></TABLE><P> </P><P>Also, are these representations of the table you are trying to get results from?</P>Mon, 20 Jan 2020 10:27:03 GMTGCase2020-01-20T10:27:03ZLeft join with empty values as one of the keys
https://community.dataiku.com/t5/Using-Dataiku-DSS/Left-join-with-empty-values-as-one-of-the-keys/m-p/4219#M2985
<P>Hi,</P><P>I have difficulties to make a left join with multiple columns as keys.<BR />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.<BR />For example :<BR />Key : Columns 1 , 2 and 3.<BR /><BR />left table : A B C D<BR />D E Null F<BR /><BR />on the right table:<BR />A B C G<BR />D E Null H<BR /><BR />result :<BR />A B C D G<BR />D E Null F <STRONG>Null<BR /><BR /></STRONG>So Dataiku seems to not recognize an empty value as a valid key and so it is removing the values.</P><P>Is there a way to avoid this problem ?<BR /><BR />Thanks !</P>Thu, 16 Jan 2020 08:45:51 GMThttps://community.dataiku.com/t5/Using-Dataiku-DSS/Left-join-with-empty-values-as-one-of-the-keys/m-p/4219#M2985jack2020-01-16T08:45:51ZRe: Left join with empty values as one of the keys
https://community.dataiku.com/t5/Using-Dataiku-DSS/Left-join-with-empty-values-as-one-of-the-keys/m-p/4250#M3001
<P>Jack,</P><P>What recipe engine are you using?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="GCase_0-1579515453672.png" style="width: 400px;"><img src="https://community.dataiku.com/t5/image/serverpage/image-id/313i8EB0CFBC833D64EB/image-size/medium?v=1.0&px=400" title="GCase_0-1579515453672.png" alt="GCase_0-1579515453672.png" /></span></P><P>Also</P><P> </P><TABLE width="256"><TBODY><TR><TD>LEFT Table</TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>Col 1</TD><TD>Col 2</TD><TD>Col 3</TD><TD>Col 4</TD></TR><TR><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD></TR><TR><TD>D</TD><TD>E</TD><TD><EM>NULL</EM></TD><TD>F</TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>RIGHT Table</TD><TD> </TD><TD> </TD></TR><TR><TD>Col 1</TD><TD>Col 2</TD><TD>Col 3</TD><TD>Col 4</TD></TR><TR><TD>A</TD><TD>B</TD><TD>C</TD><TD>G</TD></TR><TR><TD>D</TD><TD>E</TD><TD><EM>NULL</EM></TD><TD>H</TD></TR></TBODY></TABLE><P> </P><P>Also, are these representations of the table you are trying to get results from?</P>Mon, 20 Jan 2020 10:27:03 GMThttps://community.dataiku.com/t5/Using-Dataiku-DSS/Left-join-with-empty-values-as-one-of-the-keys/m-p/4250#M3001GCase2020-01-20T10:27:03Z