https://communities.sas.com/t5/SAS-Visual-Analytics/Data-Preparation-Conditional-Joins/m-p/451822#M9840 <P>Hi</P><P>&nbsp;</P><P>I have run into difficulty when trying to build a data query using the data preparation tool.&nbsp; I'm wondering if this is a restriction of the data prep tool and if I need something like DI Studio?</P><P>&nbsp;</P><P>I would like to do a conditional JOIN, specifically using an ISNULL statement to JOIN and a certain ID - if another ID happens to be NULL</P><P>&nbsp;</P><P>Can anyone help?</P> Fri, 06 Apr 2018 11:09:21 GMT Adam_Buckley 2018-04-06T11:09:21Z https://communities.sas.com/t5/SAS-Visual-Analytics/Data-Preparation-Conditional-Joins/m-p/451822#M9840 <P>Hi</P><P>&nbsp;</P><P>I have run into difficulty when trying to build a data query using the data preparation tool.&nbsp; I'm wondering if this is a restriction of the data prep tool and if I need something like DI Studio?</P><P>&nbsp;</P><P>I would like to do a conditional JOIN, specifically using an ISNULL statement to JOIN and a certain ID - if another ID happens to be NULL</P><P>&nbsp;</P><P>Can anyone help?</P> Fri, 06 Apr 2018 11:09:21 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Data-Preparation-Conditional-Joins/m-p/451822#M9840 Adam_Buckley 2018-04-06T11:09:21Z https://communities.sas.com/t5/SAS-Visual-Analytics/Data-Preparation-Conditional-Joins/m-p/451827#M9841 <P>Can you elaborate, perhaps write a skeleton SQL, and small set of sample data?</P> <P>Perhaps an outer join will work for you...</P> Fri, 06 Apr 2018 11:27:43 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Data-Preparation-Conditional-Joins/m-p/451827#M9841 LinusH 2018-04-06T11:27:43Z