Forum Discussion
merging queries
I need help! I have been troubleshootiong this for hours! I have 2 tables: Inventory with 11,597 records & Invaging with 2044 records and I am doing a left outer join to merge the results from in...
Well, a Left Outer join, to my understanding should actually return all of the records in the left table, 11,597 theoretically.
But ImkeF is far better at M than I so perhaps she can shed some light on the situation.
Cannot spot anything really suspicious here. You have many redundant "Reordered Columns"-steps in here that you could remove (despite the last). But I would be surprised if they cause trouble.
Just to check: When you say the load returns only 1000 rows, do you really mean the load to the data model or just the preview in the query editor?