Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
in data base i have data from 01-01-2020 to till date
when loading data into qlik,
1. for 2020 and 2021 need to take only month end data like 31-01-2020,29-02-2020 ...........31-01-2021......31-12-2021
for previous years need to load only month end data
2.for current year daily data....
note:incremental load not in place ,every time need to load all data.
i am trying like below:
test:
load * from table where match(datefield,monthend(datefield)) and year(datefield)<year(today());
concatenate
load * from table where year(datefield)>=year(today());
is this right approach ?