Discussion board where members can learn more about Qlik Sense App Development and Usage.
I want to integrate 2 tables below, and get the integrated table.
I would appreciated if you could tell me a sample of load script.
A, B, C
1, 2, -
2, 2, -
3, -, 3
3, -, 4
Thanks in advance.
You can use the CONCATENATE keyword to force concatenation of records from a source table to a table created earlier in the script.
LOAD A, B FROM ...somewhere...;
CONCATENATE ([Integrated table])
LOAD A,C FROM ...somewhere else...;
View solution in original post
Thank you so much for your quick response!!
As your script, I tried, but I have got an error"Table AA not found".
Could you give me more advice??
the following is my script.
AA:Load *Resident A;
Load *Resident B;
Hi, seems that you are previously loading table 'A', with the same fields as 'AA' (because the use of '*'), so it's autoconcatenating in table 'A', to avoid this you can use 'NoConcatenate':
NoConcatenateLoad *Resident A;
If you keep all tables it will create a lot of syntethic keys (tables joined by more than one field), maybe you want something like:
LOAD * Resident B;
DROP Table B;
Or try renaming fields in 'AA' table to avoid unwanted keys.
Thank you very much!
I resolved the problem. Thanks again.