Wondering if anyone can assist. I have 2 queries (Source & Destination).
I want to Left Join Destination to Source, however I want to merge upto a certain step in the Source to avoid breaking the Query Fold in the destination. Just wanted to know if this is possible and how would I go about doing this?
I ran some tests this morning using sample data online and the function definitely works in the Dataflow.
I then reviewed my query and after going each step I got it work. For some reason which I am not clear yet, it had something to do with a Referenced Query. Having changed the steps in the Referenced Query seemed to do the trick.