Multiple QVD File attached

[sagaraperera]

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

[vinieme12]

Try below:

Load *

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

[vinieme12]

or try

For i = 2016 to 2017

Load *

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

Next i

[sagaraperera]

Mr. Vineeth Pujari

Thanks in script are work.

sagara

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

[vinieme12]

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