Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is Script :
Publisher:
LOAD DISTINCT
max(DATE) AS BOOKING_MONTH_PUBLISHER
FROM
$(QvdLogisticsFolder)\Date_SourceTable.qvd (qvd)
WHERE DATE = $(CURRENT_MONTH);
// Get last available month with inventory Balance information (2011-10-06)
// this will be used as enddate for loading of Inventory Turns
Inventory_Balance_Max_Date:
LOAD
DISTINCT MAX(INV_BAL_DATE) as MAX_BAL_DATE
FROM $(QvdFinanceFolder)\Inventory_Balance_SourceTable.qvd (qvd);
LET LAST_BAL_DATE = Peek('MAX_BAL_DATE',0,Inventory_Balance_Max_Date);
Trace LAST_BAL_DATE => $(LAST_BAL_DATE);
/*---------------------------------------------------------------------------*/
/* INTRO TABLES */
/*---------------------------------------------------------------------------*/
Intro_Version_Management_Table:
LOAD DISTINCT
[Version] AS 'Intro Version Management Version'
, [Date] AS 'Intro Version Management Date'
, [Description] AS 'Intro Version Management Description'
, 'qmem://<builtin>/' & [Symbol] AS 'Intro Version Management Image'
FROM
[$(DataFolder)/EU Logistics Scorecard - Version Management.xls] (biff, embedded labels, table is [Version Management$])
;
Intro_Contacts:
LOAD DISTINCT
[Pin Number] AS 'Intro Contacts Pin Number'
, [Full Name] AS 'Intro Contacts Full Name'
, [Area] AS 'Intro Contacts Area'
, [eMail] AS 'Intro Contacts eMail'
, [Phone] AS 'Intro Contacts Phone'
FROM
[$(DataFolder)/EU Logistics Scorecard - Version Management.xls] (biff, embedded labels, table is [Contacts$])
;
/*---------------------------------------------------------------------------*/
Problem is solved