topic Re: how to load multiple qvds in QlikView

how to load multiple qvds

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

hi all how do i load multiple qvds,

i have qvds's like

1)icaps_2015_12_31.qvd

2)icaps_2016_01_29.qvd (week day qvd)

3)icaps_2016_02_29.qvd (week day qvd)

4)icaps_2016_03_23.qvd

5)icaps_2016_03_24.qvd

6)icaps_2016_03_25.qvd

7)icaps_2016_03_26.qvd

8)icaps_2016_03_27.qvd

where i have to load latest 5 days qvd and last 2 month qvd and have to make as one qvd

and last year qvd and last 2 months qvd have to make as one qvd

i am able to achieve loading of latest 5 days qvds,

last 2 months qvds i am not able to load as it is month end data but it is weekday not weekend data

please help me to achieve this

thanks,

shruthi

Chanty4u — Thu, 14 Apr 2016 17:59:43 GMT

chk dis

maxgro — Thu, 14 Apr 2016 19:07:43 GMT

you can use a loop

// last 5 days, including today

FOR i=0 to 4

LET v5d = 'icaps_' & date(today(1)-$(i), 'YYYY_MM_DD') & '.qvd';

Table:

LOAD *

FROM [$(v5d)] (qvd);

NEXT;

// last 2 months

FOR i=0 to 1

LET v5d = 'icaps_' & date(addmonths(today(1),-$(i)), 'YYYY_MM_??') & '.qvd';

Table:

LOAD *

FROM [$(v5d)] (qvd);

NEXT;