Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

urgent change : Please remove the two row IT from this list and if possible add a information : like : " For any incident please raise a incident ticket".

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$])

;

/*---------------------------------------------------------------------------*/

1 Reply
Not applicable
Author

Problem is solved