Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
r20017aaa
Creator III
Creator III

Dynamic update - add one table to another

what Dynamic table statement (yes I really need Dynamic statement - not looking for another solution)

can I use to add the content on table 2 to table 1 so table 1 will look like

 

NameScore
A1
B2
C3
D4
E10
F20

something like : Update table1 set ...

starting point:

table1:

LOAD * INLINE [

    Name, Score

    A, 1

    B, 2

    C, 3

    D, 4

];

Qualify *;

table2:

LOAD * INLINE [

    Name, Score

    E, 10

    F, 20

];

unQualify *;

Many thanks,

Raphael

1 Solution

Accepted Solutions
t_chetirbok
Specialist
Specialist

Is your "enable dynamic update" checkbox is checked?  The table will be changed only in your visualization

View solution in original post

10 Replies
sunny_talwar

When you say dynamic, do you mean while reloading or is this something you expect to happen from the front end?

t_chetirbok
Specialist
Specialist

do you want by clicking on a button update your table1? (as dynamic update is an action for trigger)

stabben23
Master
Master

use join or concatenate instead of qualify maybe.

table1:

LOAD * INLINE [

    Name, Score

    A, 1

    B, 2

    C, 3

    D, 4

];

join/concatenate //here

table2:

LOAD * INLINE [

    Name, Score

    E, 10

    F, 20

];

r20017aaa
Creator III
Creator III
Author

yes clicking a button then Action: Dynamic Update, thanks

r20017aaa
Creator III
Creator III
Author

yes, this is what I am trying to do, but so far I used Dynamic update to update one line at a time, now I want to do bulk update, thanks

r20017aaa
Creator III
Creator III
Author

Cannot in the given situation but thanks

t_chetirbok
Specialist
Specialist

try this

='INSERT INTO table1 (Name, Score)

values '&

'('&chr(39)&Concat(table2.Name&chr(39)&','&table2.Score, '),('&chr(39))&')'

&';'

r20017aaa
Creator III
Creator III
Author

Clicking2017-12-20_13-48-42.bmp on button but no change to table1

t_chetirbok
Specialist
Specialist

Is your "enable dynamic update" checkbox is checked?  The table will be changed only in your visualization

View solution in original post