Qlik Comrades please help. I have 4 .mdb source documents that I am using in my script. For my first sheet I am combining 2 sources to create one table and the remaining 2 sources to create a second table on my second sheet by using Left Join, no problem. For my third sheet I need to pull all four sources ( currently 2 tables) into one table. What is the correct approach? Everything I have tried so far has rendered incorrect results. Thanks in advance for your help!
Hmm, sounds very strange, you might want to double check your results.
If you have the same fields and you use LEFT JOIN, then QlikView will only load those rows where all fields already existed in the first table. Since all fields are the same, they are all used as JOIN key fields - including quantities, prices, etc... So, unless all fields are exactly the same, LEFT JOIN won't include them in the result.
Concatenation shouldn't create another row with NULL values, unless it's coming from one of the 4 tables...