Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic Data Update

Hi,

I tried to Insert multipe rows with a commande like "Insert Into [Table1] (Col1, Col2, Col3) Select Col1, Col2, Col3 From [Table2]" but it didn't work.

Does somebody know how to do that ?

Thk for your help.

1 Reply
Master II
Master II

The usual syntax in QV would be:

Table1: LOAD Col1, Col2, Col3 RESIDENT Table2

This assuming that Table2 has already been loaded (and is resident in memory), if not you need to replace the "RESIDENT Table2" with a "FROM" and a filename.

HTH
Peter