Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 *.
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 *.