Hi,
Im new at Qlik Sense and Im wondering if you could help me with my problem. Does anyone here know how to join two tables using 'Data Load Editor' on Qlik Sense? Does Qlik Sense Join can behave like SQL? BTW, Im using Excel File with 900K rows FYI. For further information to my question, here is my sample:
***Here I want to use this table, named Table1
[Table1]:
LOAD
[Name]
[Nickname]
[Address]
[Number]
[Birthday]
FROM [lib://DOCUMENTS/data.xlsx]
(ooxml, embedded labels, table is data);
***And join it to Table2, Containing
[Table2]:
LOAD
[Name] AS Name[
[Address]
[Bank No]
[Bank Type]
FROM [lib://DOCUMENTS/security.xlsx]
(ooxml, embedded labels, table is security);
**Using Name and Address only...
NOTE: I don't want to use Qlik Sense auto-join because it returns with "Synthetic Key"
THANK YOU!
!!