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.
Ok i had a simple extract script which was:
Store INFOTABLE into $(vDetailsQVDDirectory)\INFOTABLE.qvd;
Drop table INFOTABLE;
This extract was then used in a load script:
And loaded everything.
I then wanted to split the load for schedule efficiency and archive purposes to two separate extract scripts:
WHERE YEAR != '2017';
Store INFOTABLEPY into $(vDetailsQVDDirectory)\INFOTABLEPY.qvd;
Drop table INFOTABLEPY;
WHERE YEAR = '2017';
Store INFOTABLECY into $(vDetailsQVDDirectory)\INFOTABLECY.qvd;
Drop table INFOTABLECY;
These are then loaded by using a load script with a * to pick them both up:
However when loaded together the new way has less rows (and missing data) than the old way.
Why is this happening, I am not limiting any data?
Image to help people:
Got this working with correct data by defining both qvds with their own loads:
View solution in original post
Check this part
What is your intend to show in where condition
You may need something like below with semicolon ended
Where YEAR <> '2017';
And you used Exit script for each load. Why? And finally what is the issue you are facing here
semi colons in and exit script out, my commented out parts didn't carry over, ignore the exit script.
my problem is
Since the filter is on Year, check the db tables for null values in the Year field.
Just ran the code in SQL developer
WHERE YEAR IS NULL
and returned no data so i cant be that
Just to rule out the Year filter issue try
SELECT distinct YEAR
To see for any incosistencies
Can you specify how these missing rows and missing data look like? This could give us a hint what's going on.
Good idea! But unfortunately nothing inconsistent:
Nothing obvious, its 470,000 rows vs 462,000 rows
the ones that are missing have no spurious data
A last try on the year field:
Do a group by year and sum one of the values and do a count of one of the other fields if possible
SELECT YEAR, count(fieldname), sum(Sales)
GROUP BY YEAR;