Hi ,
I have a flat file that is semicolon sepearated as a source .
The file has something like this .
ABC;bcd;12;
BCD;AAA;15;V;
There is a column that comes in few lines later in the source , so i hae an isue that my variales tab is picking up my ata base on line 1 I guess
so is there a any way to get aroun this to decie the columns based on the whole file .
Thanks,
Load File
-
- Community Contributor
- Posts: 287
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: Load File
You can use a template file that has as many columns as you want as the datasource when setting up the TI process and then point the DatasourceNameForServer variable to the actual file in the prolog tab of your TI process.