join multiple files at the same time with asterisk (*)

[laujerry]

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);

[swuehl · Accepted solution]

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
];

[laujerry]

thanks all input from u

this looks like a more preferable solution to me