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
many thnaks