Hello Experts,
I am starting to learn concatenate function in Qlikview and I want to replace column f2 from table 2 into table 1
so the intended result as the following table:
| f1 | f2 | f3 |
| a | a | c4 |
| b | b | c5 |
| c | b | c6 |
| d | b | c2 |
| e | c | c3 |
table2:
table1:
I used the code below and the result table turn out to be this:
| f1 | f2 | f3 |
| a | a | c1 |
| a | b | c4 |
| b | b | c5 |
| c | b | c6 |
| d | b | c2 |
| e | c | c3 |
LOAD f1,
f2,
f3
FROM
C:\table1.xlsx
(ooxml, embedded labels, table is Sheet1);
Concatenate
LOAD f1,
f2,
f3
FROM
C:\table2.xlsx
(ooxml, embedded labels, table is Sheet1);
PLEASE HELP!!! THANKS IN ADVANCE!!
