TM1 Forum

I would like to find out if this is TM1 limitation or there is any other way i can do this ?

when i use data file as my datasource type, the preview only shows the first 10 rows of the file. I am using * as my delimiter and the maximum column it can go is 15.

for the first 10 rows, the maximum column i have is only 10 and starting row 12, the total column number will be 15.

so how can i make it in a way to define 15 columns instead of default it define as 10 ?

winsonlee wrote:I would like to find out if this is TM1 limitation or there is any other way i can do this ?

when i use data file as my datasource type, the preview only shows the first 10 rows of the file. I am using * as my delimiter and the maximum column it can go is 15.

for the first 10 rows, the maximum column i have is only 10 and starting row 12, the total column number will be 15.

so how can i make it in a way to define 15 columns instead of default it define as 10 ?

You don't have to use the live data source when you're defining your TI process. Just make a copy of the file, cut out the first 11 rows so that the new first row is what was row 12 of your original file, and point to that as your data source. That way you will get the 15 variables defined for your columns. Set them to whatever data types you need them to be. When you're finished you can change the data source back to your original file. As long as you leave the Variables tab alone when you're editing the TI process you won't lose the 15 columns.

thanks for the reply. this information is helpful!