This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have done this before with other QV solutions but this one isnt working.
I have 2 load scripts from 2 files (previous and current year)
1 qvw (front end)
Extract script 1 code (SQL is simplified for example) DiaryPY.qvw:
Load * ;
SELECT * FROM Diary WHERE Year = '2017';
STORE Diary INTO C:Users\DiaryPY.QVD;
DROP TABLE Diary;
Extract script 2 code (SQL is simplified for example) Diary.qvw:
SELECT * FROM Diary WHERE Year = '2018';
STORE Diary INTO C:Users\DiaryCY.QVD;
Load script 1 code (Qualifies are for other tabs that are working fine):
UNQUALIFY Field1, Field2, Field3, Field4;
FROM C:Users\DiaryPY.QVD (qvd);
FROM C:Users\DiaryCY.QVD (qvd);
The issue I am having is when i look at the Available fields loaded in, it is splitting them as Diary.Field1, Diary.Field2 etc and then DiaryCY.Field1, DiaryCY.Field2 etc.
I want them all to be recognised as the same table (like a UNION in SQL).
For anyone who is having this problem, its is the UNQUALIFY it needs to be move to the bottom.
View solution in original post
use concatenate maybe?
Still the same issue
try this then, the table Field will be used as a flag to keep them separated.
'PY' as table
'CY' as table
First merge the tables (using the CONCATENATE prefix that Staffan suggested), then Qualify the fields by loading them into a new Resident table..
Qualify will always er... qualify fields from different sources by tagging the field names.
How can i do this?
This is ineteresting, wouldn't expect this behaviour. I guess QUALIFY uses provided label and if no label provided then it tries to get label from source (hence Diary.Field5 but DiaryCY.Field5). I'd try two things:
FROM C:Users\Diary*.QVD (qvd);
CONCATENATE (Diary) LOAD