Add more data into existing QVD

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

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 ???

Re: Add more data into existing QVD

Peter_Cammaert — Thu, 18 May 2017 16:05:32 GMT

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.

topic Re: Add more data into existing QVD in QlikView

Add more data into existing QVD

Re: Add more data into existing QVD