Hi   I have run into difficulty when trying to build a data query using the data preparation tool.  I'm wondering if this is a restriction of the data prep tool and if I need something like DI Studio?   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   Can anyone help? ... View more