topic Re: CALENDAR MALFUNCTION in QlikView

CALENDAR MALFUNCTION

Tue, 24 Feb 2015 15:40:09 GMT

hello, i have not had too much trouble with my calendars before, but i continue to get errors with this file. it says the templcalendar table cannot be found so then the rest does not work. any ideas?

thanks for the help,

Parrish

Re: CALENDAR MALFUNCTION

simospa — Tue, 24 Feb 2015 15:51:16 GMT

Hi Parrish,

did you try to run the script in debug mode, so you can see step by step the reload process?

PS: otherwise try to post a sample of two xls files you are using (CALENDAR.xlsx and SHIPMENT FILE.xlsm)

Re: CALENDAR MALFUNCTION

Tue, 24 Feb 2015 16:17:39 GMT

it looks like i was just overlooking the fact that i had not entered "MAPPING" infront of load...thank you though!

Re: CALENDAR MALFUNCTION

MK_QSL — Tue, 24 Feb 2015 17:08:16 GMT

1) you are missing Mapping Keyword in DATEMAP table...

so when you are using

Applymap('DATEMAP',[Period/yr],0) as Period_Date

you are not getting any Period_Date...

Try below and load again

DATEMAP:

MAPPING LOAD [Period/yr],

Period_Date

FROM

(ooxml, embedded labels, table is Calendar);