Dynamic update - add one table to another

[Anonymous]

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

[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]

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

[stabben23]

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

];

[Anonymous]

yes clicking a button then Action: Dynamic Update, thanks

[Anonymous]

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

[Anonymous]

Cannot in the given situation but thanks

[t_chetirbok]

try this

='INSERT INTO table1 (Name, Score)

values '&

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

&';'

[Anonymous]

Clicking on button but no change to table1

[t_chetirbok · Accepted solution]

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