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

How to insert records into tables residents?

I need to insert records into a table resident, as I can do?

The resident table is created from a query to SQL

1 Solution

Accepted Solutions
Carlos_Reyes
Partner - Specialist
Partner - Specialist

Do you mean you want to append new records at the end of the table? If so, you can use CONCATENATE to do it.

For example:

SQL_TABLE:

LOAD

          A,

          B,

          C

FROM SQL TABLE;

CONCATENATE (SQL_TABLE)

LOAD

          A,

          B,

          C

FROM ANOTHER SOURCE;

View solution in original post

1 Reply
Carlos_Reyes
Partner - Specialist
Partner - Specialist

Do you mean you want to append new records at the end of the table? If so, you can use CONCATENATE to do it.

For example:

SQL_TABLE:

LOAD

          A,

          B,

          C

FROM SQL TABLE;

CONCATENATE (SQL_TABLE)

LOAD

          A,

          B,

          C

FROM ANOTHER SOURCE;