TM1 Forum

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,

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.