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]);
