Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

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