Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is your "enable dynamic update" checkbox is checked? The table will be changed only in your visualization
When you say dynamic, do you mean while reloading or is this something you expect to happen from the front end?
do you want by clicking on a button update your table1? (as dynamic update is an action for trigger)
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
];
yes clicking a button then Action: Dynamic Update, thanks
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
Cannot in the given situation but thanks
try this
='INSERT INTO table1 (Name, Score)
values '&
'('&chr(39)&Concat(table2.Name&chr(39)&','&table2.Score, '),('&chr(39))&')'
&';'
Clicking on button but no change to table1
Is your "enable dynamic update" checkbox is checked? The table will be changed only in your visualization