adding concatenate column in Month wise QVD files

[#1]

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

[Kushal_Chawda]

what additional column you want to add?

[#3]

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

[Kushal_Chawda]

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

[#5]

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.

[tresesco]

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