topic Re: adding concatenate column in Month wise QVD files in QlikView

adding concatenate column in Month wise QVD files

Fri, 04 Dec 2015 06:23:36 GMT

Dear Expert,

i have month wise separate Trade QVD files for Example for JAN-2014 i have <QVD file Name>-JAN2014.qvd for FEB-2014 i have <QVD file Name>-FEB2014.qvd and so on.

i have to add some additional Columns into all qvd files. if it was only one qvd file it was easy.

i want to read all qvd files from a folder and add columns into it and store into the same location.

how can i do that please help

Thanks

JKV

Re: adding concatenate column in Month wise QVD files

Kushal_Chawda — Fri, 04 Dec 2015 06:52:23 GMT

what additional column you want to add?

Re: adding concatenate column in Month wise QVD files

Fri, 04 Dec 2015 07:04:03 GMT

Hi,

i wanted to create some key field by adding two columns. i have done by using for loop. i read each file one by one in for loop and add additional columns and save with same name

Thanks

JKV

Re: adding concatenate column in Month wise QVD files

Kushal_Chawda — Fri, 04 Dec 2015 07:07:20 GMT

So to create the Key field , are you using the two fields from the same QVDs ?

Re: adding concatenate column in Month wise QVD files

Fri, 04 Dec 2015 07:10:26 GMT

yes,

i can do the same at load time also. but it was taking a time to load into main qvw application. so i done on all qvd files and keep into the qvd only. so load time can save.

Re: adding concatenate column in Month wise QVD files

tresB — Fri, 04 Dec 2015 07:32:53 GMT

Try like:

FOR Each File in filelist ('yourpath'&'\*.qvd')

    LOAD
          *,
          'AA' as NewField
From $(File)(QVD);

Let vTable=SubField(SubField('$(File)','\',-1),'.',1);

Store $(vTable) Into $(vTable)&'.qvd (qvd)';

NEXT File