Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
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