Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Tags (2)
1 Solution

Accepted Solutions
carlos_reyes_qv
Valued Contributor

Re: How to insert records into tables residents?

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;

1 Reply
carlos_reyes_qv
Valued Contributor

Re: How to insert records into tables residents?

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;

Community Browser