Loading latest quarter field from qvd

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Here is my code below. this code is at the data model level. i created the qvd using a QVD generator.

Currently the files in the qvd are for: December 2017 - 201712 and January 2018 - 201801

I want to load only the the latest data from the qvd - 201801 and not 201712

This is to be done in script as it will be binary loaded into another app

PMonthly stores 201712 and 201801 in text format

Performance:

LOAD Pven,

PKey,

PMea,

PAct as Actual_Perf,

PMonthly,

Date(MakeDate(Left(PMonthly,4),Right(PMonthly,2),'01'),'MMM YYYY') as M_Perf_Month

FROM

$(vQvdPath)Manage_Perf.qvd(qvd);

Left Join(Performance)

load

max(M_Perf_Month) as maxPerfmonth

resident Performance;

Let vVMO_Current_M_Perf_Date = peek('maxPerfmonth',0,'Performance');

Let vVMO_Latest_M_Perf_Date = num(monthname($(vVMO_Current_M_Perf_Date)));

Re: Loading latest quarter field from qvd

sunny_talwar — Wed, 07 Feb 2018 18:21:38 GMT

Try this may be

Right Join(Performance)

load

max(M_Perf_Month) as M_Perf_Month

resident Performance;