Data load editor join tables

[wanyunyang]

Hi guys,

I have two tables: A and B in data load editor, with a same field: CUSTOMER, in which way will QLIK SENSE automatically join this two tables on CUSTOMER field (INNER, OUTER, LEFT, RIGHT)?  

Thanks in advance!

[jerifortune]

You can avoid counting the Amount field. It could be that you have a row with the same amount. If that is the case try using Distinct keyword

[wanyunyang]

I had both SELECT and LOAD in my data load editor, I think that was the reason. Now I have deleted LOAD and everything is correct. Is there a rule saying SELECT and LOAD can't appear together?

[evans7882]

17k views and 0 likes as of 2/1/22.