04-06-2018 07:09 AM
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?