Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Parrish,
did you try to run the script in debug mode, so you can see step by step the reload process?
S.
PS: otherwise try to post a sample of two xls files you are using (CALENDAR.xlsx and SHIPMENT FILE.xlsm)
it looks like i was just overlooking the fact that i had not entered "MAPPING" infront of load...thank you though!
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);