Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

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

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.