Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
just want to understand that if below joining script is not supported by qlikview / qliksense joining (now i am using qlikview)
thank
table1:
load ....
from abc.qvd(qvd);
join (table1)
load ...
from file_*.qvd(qvd);
i found that not all file_*.qvd are loaded/joined
i also tried writing with a preceding load but also not work
join (table1)
load *;
load ...
from file_*.qvd(qvd);
Just swapping the order of joined tables should do it:
Tbl_1:
LOAD 1 as A,
'A' as Key
AutoGenerate 1;
STORE Tbl_1 into Tbl_1.qvd;
DROP Table Tbl_1;
Tbl_2:
LOAD 2 as A,
'B' as Key
AutoGenerate 1;
STORE Tbl_2 into Tbl_2.qvd;
DROP Table Tbl_2;
Tbl:
LOAD A,
Key
From Tbl_*.qvd(qvd);
RIGHT JOIN (Tbl)
LOAD * Inline [
F1, A
1, 1
2, 2
];
thanks all input from u
this looks like a more preferable solution to me