topic Re: Multiple QVD File attached in QlikView

Multiple QVD File attached

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

Dear All

I have number of QVD files with same content but in different name. normally i import QVD files to one by one. as given below

SALES:

LOAD BCOD,

CLA_CODE,

PRD_CODE,

POLICY_NO,

REF_NO,

DATE(floor(MARKETING_DATE)) as MARKETING_DATE,

//DATE(monthstart(MARKETING_DATE), 'MM-YYYY') as MonthYear,

MDATE,

YEAR,

MONTH,

NAME,

ME_CODE,

//TRN_DATE,

DATE(floor(TRN_DATE)) as TRN_DATE,

TRAN_YEAR,

TRAN_MONTH,

POL_PERIOD_FROM,

SCCOD,

IF(SCCOD>='SC0','COUNTER')AS CITY_COUNTER,

CP,

RS,

TC,

GROSSTOT,

TYPE,

N_R_NOS1,

F_NOS2

FROM

G:\qlickviwe\Sales\SALES2016.QVD

(qvd);

Concatenate(SALES)

LOAD BCOD,

CLA_CODE,

PRD_CODE,

POLICY_NO,

REF_NO,

DATE(floor(MARKETING_DATE)) as MARKETING_DATE,

//DATE(monthstart(MARKETING_DATE), 'MM-YYYY') as MonthYear,

MDATE,

YEAR,

MONTH,

NAME,

ME_CODE,

//TRN_DATE,

DATE(floor(TRN_DATE)) as TRN_DATE,

TRAN_YEAR,

TRAN_MONTH,

POL_PERIOD_FROM,

SCCOD,

IF(SCCOD>='SC0','COUNTER')AS CITY_COUNTER,

CP,

RS,

TC,

GROSSTOT,

TYPE,

N_R_NOS1,

F_NOS2

FROM

G:\qlickviwe\Sales\SALES2017.QVD

(qvd);

is there any possibility to import all the all QVD files i want to script at ones without copy & paste one by one.

sagara

Re: Multiple QVD File attached

vinieme12 — Tue, 07 Feb 2017 11:13:45 GMT

Try below:

Load *

From G:\qlickviwe\Sales\Sales*.QVD (QVD);

Re: Multiple QVD File attached

vinieme12 — Tue, 07 Feb 2017 11:15:30 GMT

or try

For i = 2016 to 2017

Load *

From G:\qlickviwe\Sales\Sales$(i).QVD (QVD);

Next i

Re: Multiple QVD File attached

sagaraperera — Tue, 07 Feb 2017 11:21:06 GMT

Mr. Vineeth Pujari

Thanks in script are work.

sagara

On 7 February 2017 at 16:45, Vineeth Pujari <qcwebmaster@qlikview.com>

Re: Multiple QVD File attached

vinieme12 — Tue, 07 Feb 2017 14:06:49 GMT

Glad to help

sagaraperera Can you mark a response as correct and close the thread please

Qlik Community Tip: Marking Replies as Correct or Helpful