Hello All-
I'm a new to Tm1 and truly need assistance.
The data source for tm1 is from excel. The file is not too large, but 60,000 records in each sheet viz, sheet1,sheet2,sheet3 in one single excel file.
I can process sheet1 without issue. My question is how to simultaneously process all the 3 sheets.
Please advice.
--Srrinivas
Import from excel file having 3 tabs
-
Duncan P
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Import from excel file having 3 tabs
Using the standard XL ODBC driver the sheet name corresponds to the table name in the SQL statement.