Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table integration

Hello!

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.

[table1]

A, B

1, 2

2, 2

[table2]

A, C

3, 3

3, 4

[Integrated table]

A, B, C

1, 2, -

2, 2, -

3, -, 3

3, -, 4

Thanks in advance.

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can use the CONCATENATE keyword to force concatenation of records from a source table to a table created earlier in the script.

[Integrated table]:

LOAD  A, B FROM ...somewhere...;

CONCATENATE ([Integrated table])

LOAD A,C FROM ...somewhere else...;


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can use the CONCATENATE keyword to force concatenation of records from a source table to a table created earlier in the script.

[Integrated table]:

LOAD  A, B FROM ...somewhere...;

CONCATENATE ([Integrated table])

LOAD A,C FROM ...somewhere else...;


talk is cheap, supply exceeds demand
Not applicable
Author

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;

CONCATENATE([AA])

Load *
Resident B;

rubenmarin

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':

AA:

NoConcatenate
Load *
Resident A;

CONCATENATE([AA])

Load *
Resident B;

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:

Concatenate (A)

LOAD * Resident B;

DROP Table B;

Or try renaming fields in 'AA' table to avoid unwanted keys.

Not applicable
Author

Thank you very much!

I resolved the problem. Thanks again.