Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please refer word doc suggest solution ASAP:
Generating Repetitive QVD in QVD Loop.Problem is we have $(Sales_Country): Table for Incremental load we wrote logic if Office&[Account period] as Keycal, and renamed to [Sales Keycal]if this is same Replace old data else Concatenate to new data
$(vProjectOGISQvdDir)\$ (Sale_Logic).qvd
(qvd)
where NOT exists([Sales Keycal]);
But to generate year wise Qvd Split written logic with in temp:resident of Increment table.
Problem facing:
QVD are generating for Incremental data .
By using same incremental table name VD are splitting into Year wise and giving Same data in QVD
Can any one help on how to integrate Year wise QVD Temp table code below the Incremental Load.
So that there will not be any more repetitive qvd.
solution expecting on
I need to integrate QVD Splitting Year wise Code below the Incremental load
Concatenate
LOAD *
FROM
$(vProjectOGISQvdDir)\$ (Sale_Logic).qvd
(qvd)
where NOT exists([Sales Keycal]);
Any help on this please stuck with errors .Any solution on QVD generation logic optimization .In word doc will give Reference for the problem
I think the reason for your not working script is how is exists() used. Exists() didn't work on table-level else on field-level for the entire loaded data. This meant without dropping your resident table it couldn't work (store as qvd and loaded from there). Further not exists() worked only with absolute unique keys on record-level:
http://community.qlik.com/message/667486#667486
- Marcus
My Requirement is in Incremental Load logic we have used where NOT exists([Sales Keycal]); as it is based on requirement giving desired output and generating qvd .But need to integrate the Year wise qvd generation logic after concatenate Load
It is not a question of whether but how. Therefore read my comment again and check the hints here:
http://community.qlik.com/search.jspa?q=incremental+load
- Marcus