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