Add more data into existing QVD

[madhuqliklondon]

Hi friends ,  sorry if this is a simple question or make no sense..

I have a QVD, called 1hour_order.qvd. What I want is I want to add one more field 'Trend' to it. how can I do it ?

Do I have to open qvd file?

when I open QVD script is

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='£#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

SET FirstWeekDay=0;

SET BrokenWeeks=0;

SET ReferenceDay=4;

SET FirstMonthOfYear=1;

SET CollationLocale='en-GB';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

LOAD [EMS Customer No.],

     [Customer No_],

     Name,

     Address,

     [Address 2],

     City,

     [Phone No_],

     [Country Code],

     Country,

FROM

(qvd);

---------------------

And my dashboard tab had got following script

UNQUALIFY*;

CustomerTemp:

LOAD [EMS Customer No.],

     [Customer No_],

//     Name,

//     Address,

//     [Address 2],

//     City,

//     [Phone No_],

//     [Country Code],

//     Country,

//     [Last Date Modified],

     [Post Code],

//     [E-Mail],

     [Not Active],

//     [VIP Brand Code],

//     DOB,

     Gender,

     [Cost Discount],

//     [Contact No_],

//     [Last DateTime Modified],

//     [Last DateTime Processed],

     [Date First Ordered],

     Banned,

     [Internal Flag],

     [Cohort Date],

//     [Cohort Week],

//     [Cohort WeekDay],

//     [Cohort Month],

//     [Cohort Year],

//     [Cohort QuarterName],

//     [Cohort Year-Month],

//     [Cohort Month-Year],

     NAVCompany

,date([Date First Ordered]) as [Date First Ordered (dd/mm/yyyy)]

,SubField([Post Code],' ',1) as [Cal.Post Code]

FROM

[$(vQVDFolder)1hour_orders.QVD]

(qvd);

QUALIFY*;

UNQUALIFY [EMS Customer No.],[Cal.Post Code];

Customer:

LOAD *

Resident CustomerTemp;

left join

UKPostCodePopulation:

LOAD Postcode as [Cal.Post Code],

     Population

FROM

[$(vOtherDataFolder)UKPopulation2011.xls]

(biff, embedded labels, table is [Data$]);

DROP table CustomerTemp;

How can I achieve it ???

[Peter_Cammaert]

If I understand your question well, you can try the following:

• Create a QVW and open the script editor.
• Load the QVD into a resident table.
• Add whatever field from whatever external source to your resident table.
• STORE the resident table, either in a QVD with a new name (to be safe) or on top of the existing QVD (may be risky)
• Drop the resident table.

Save the script, reload and check your (new) QVD.