Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

10 Replies
Anonymous
Not applicable
Author

many thnaks