Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Kevin,
Apply below script an it'll clear your all doubts.
Thanks but it shows an error around Line 25 saying:
The following error occured:
Field 'Name' not found
The error occured here:
?
What should I do?
Thanks! If I access these through table1 or table2, does the link works? like it will be aggregate also? 'cause I have many aggregate fields.
Link between Table1 and Table2 will work perfectly (by referring key field)!
Your link table have 3 fields...
[Name],
[Address],
[Name]'&'[Address] as key You can access "Name" or "Address" when you need them..
By this link table you can made your data model perfectly...with out any synthetic keys.
Thanks! what I mean is how I can call for example "Name" on my link table?
for example in SQL you call it by: table.Name
How about in Qlik Sense? I'm so sorry, I'm just a little bit confused, hope you all bear with me.
Thanks again.
Please elaborate More..i didn't get you..
In link table itself you can use Name field...
Okay, I want to know if I have table1 with: [Name] and [Address]
and then table2 with: [Name] and [Address] also..
and finally linktable with: [Name] and [Address] and [Key]
That's what I know, now how could I know that the [Name] that I call is from the linktable?
and not on the table only?
I hope I make myself clear... sorry.
LinkTable:
Load
Distinct
Key,
[Name],
[Address]
Resident
Table1;
Concatenate
Load
Distinct
Key,
[Name],
[Address]
Resident
Table2;
(Or)
You can load entire tables(table 1 and table2) and make a comment(//) to other fields except(Key,[Name],[Address]) as below...
link_table:
[Name],
//[Nickname]
[Address],
[Name]'&'[Address] as key
//[Number]
//[Birthday]
FROM [lib://DOCUMENTS/data.xlsx]
(ooxml, embedded labels, table is data);
concatinate(link_table)
LOAD
[Name],
[Address],
[Name]'&'[Address] as key
//[Bank No],
//[Bank Type]
FROM [lib://DOCUMENTS/security.xlsx]
(ooxml, embedded labels, table is security)
Here what happens is these 3 fields(Key,[Name],[Address]) are concatinated by make use of table 1 and table2.these table(link table)has records which are available in both the tables.
So abviously you can acess the name field form link table only.because,In table1 and table 2 name filed is not vailable.(we are commented).
Hope this help you!!!
Thanks! I think I already get what are you sayin' I will try this later!.