Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
f1 | f2 | f3 |
a | a | c1 |
d | b | c2 |
e | c | c3 |
table1:
f1 | f2 | f3 |
a | b | c4 |
b | b | c5 |
c | b | c6 |
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!!
Try something like:
LOAD f1,
f2,
f3
FROM
C:\table1.xlsx
(ooxml, embedded labels, table is Sheet1);
LOAD f1,
f2,
f3
FROM
C:\table2.xlsx
(ooxml, embedded labels, table is Sheet1) where not exists(f1);
hi
try this code.
table2:
LOAD * Inline [
f1, f2, f3
a, a, c1
d, b, c2
e, c, c3
] ;
Join
table1:
LOAD * Inline [
f1, f2, f3
a, b, c4
b, b, c5
c, b, c6] Where not Exists(f1);
then output like this
f1 | f2 | f3 |
a | a | c1 |
b | b | c5 |
c | b | c6 |
d | b | c2 |
e | c | c3 |
see attached file.
table2:
LOAD * Inline [
f1, f2, f3
a, a, c1
d ,b, c2
e ,c, c3
];
table1:
LOAD * Inline [
f1 ,f2, f3
a ,b ,c4
b ,b, c5
c ,b ,c6
] where not exists(f1);
It seems some time the user posting the issue just forget to mention what is right and helpful.
Hello Dear,
Using when not exists(f1) statement in the end I get this table:
f1 | f2 | f3 |
a | b | c4 |
b | b | c5 |
c | b | c6 |
d | b | c2 |
e | c | c3 |
which is not the one I am hoping to get...
I want to get this result:
f1 | f2 | f3 |
a | a | c4 |
b | b | c5 |
c | b | c6 |
d | b | c2 |
e | c | c3 |
Hello Dear,
Using when not exists(f1) statement in the end I get this table:
f1 | f2 | f3 |
a | b | c4 |
b | b | c5 |
c | b | c6 |
d | b | c2 |
e | c | c3 |
which is not the one I am hoping to get...
I want to get this result:
f1 | f2 | f3 |
a | a | c4 |
b | b | c5 |
c | b | c6 |
d | b | c2 |
e | c | c3 |
f1 | f2 | f3 |
a | a | c4 |
b | b | c5 |
c | b | c6 |
d | b | c2 |
e | c | c3 |
Thanks for the help, but this is the table I was trying to get...
PLEASE HELP!!
LOAD * Inline [
f1, f2, f3
a, a, c1
d ,b, c2
e ,c, c3
] where not exists(f1);
table1:
LOAD * Inline [
f1 ,f2, f3
a ,b ,c4
b ,b, c5
c ,b ,c6
] ;
Then Try:
LOAD f1,
f2,
f3
FROM
C:\table2.xlsx
(ooxml, embedded labels, table is Sheet1) ;
LOAD f1,
f2,
f3
FROM
C:\table1.xlsx
(ooxml, embedded labels, table is Sheet1) where not exists(f1);