Qlikview table joins -1

Anonymous — Wed, 27 Mar 2013 11:06:11 GMT

Hi guys,

I have multiple files i'd like to load into Qlikview and have been succesful so far - loading them in is fine. I'd like to all put them into the 'SIP' table but when i use the following code, it loads them into:

SIP-1

SIP-2

SIP-3

etc.

SET qv_path= 'O:\Register-';

SET qv_filetype= 'xls';

qualify*;

SIP:

load

@1:47 as [PAYROLL],

@47:63 as [AccountNum],

FROM $(qv_path)*.$(qv_filetype) (fix, codepage is 1252,header is 1 lines);

Unqualify*;

Can anyone help me?

Re: Qlikview table joins -1

Gysbert_Wassenaar — Wed, 27 Mar 2013 11:27:56 GMT

If you use qualify * then all the fields will be prefixed with a table name. So the first fields will be prefixed with SIP: SIP.PAYROLL. The next load will load PAYROLL and since that's not SIP.PAYROLL the data will be loaded in a new table and get prefixed with the new table name. Then the same happens again and again for the other loads. So, don't use qualify *.

topic Re: Qlikview table joins -1 in QlikView

Qlikview table joins -1

Re: Qlikview table joins -1