topic Re: Dynamic update - add one table to another in QlikView

Dynamic update - add one table to another

Anonymous — Wed, 20 Dec 2017 12:12:12 GMT

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

Name	Score
A	1
B	2
C	3
D	4
E	10
F	20

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

Re: Dynamic update - add one table to another

sunny_talwar — Wed, 20 Dec 2017 12:16:15 GMT

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

Re: Dynamic update - add one table to another

t_chetirbok — Wed, 20 Dec 2017 12:17:07 GMT

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

Re: Dynamic update - add one table to another

stabben23 — Wed, 20 Dec 2017 12:17:27 GMT

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

];

Re: Dynamic update - add one table to another

Anonymous — Wed, 20 Dec 2017 12:18:09 GMT

yes clicking a button then Action: Dynamic Update, thanks

Re: Dynamic update - add one table to another

Anonymous — Wed, 20 Dec 2017 12:19:18 GMT

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

Re: Dynamic update - add one table to another

Anonymous — Wed, 20 Dec 2017 12:21:07 GMT

Cannot in the given situation but thanks

Re: Dynamic update - add one table to another

t_chetirbok — Wed, 20 Dec 2017 13:41:48 GMT

try this

='INSERT INTO table1 (Name, Score)

values '&

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

&';'

Re: Dynamic update - add one table to another

Anonymous — Wed, 20 Dec 2017 13:51:05 GMT

Clicking on button but no change to table1

Re: Dynamic update - add one table to another

t_chetirbok — Wed, 20 Dec 2017 13:56:38 GMT

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

Re: Dynamic update - add one table to another

Anonymous — Wed, 20 Dec 2017 14:00:34 GMT

many thnaks