Ascii Data Source Column Limit

[jim wood]

Guys,

Do we know if there is a limit to teh number of columns within a comma delimited file that TI can deal? A guy I am working with is trying to import a text file with 96 columns. When TI tries to preview the file it crashes,

Jim.

[tomok]

I don't know but am very curious. I would just trial and error it, reducing it by 5 at a time until you can get it to preview properly. Then adding back one at a time to get the actual limit. If you do it this way let us know what the result is. The next question is whether the limit is just for using the preview function, i.e., how many variables can you add manually, without using the preview function to build the list for you.

[Steven Marshall]

Hi Jim,

Can't say I've come across any limits, we have a fairly large csv source file with 105 columns which handles fine and 82 columns over ODBC ...

Steven

[MSidat]

Jim,

Depending on what version of 9.5.2 you are on, could be related to the following:

http://www.tm1forum.com/viewtopic.php?f ... 531#p19733

[jim wood]

Many thanks guys for all your replies. It looks like it is the bug mentioned in the last post. Their server is 9.5.2 FP1 but their clients are still 9.5.1. They are now looking at how they can upgrade their clients.

Thanks again,

Jim.

[dr.nybble]

FWIW the maximum number of columns is 530.

[jim wood]

Thanks for letting me know. I'm not sure who would want to a load a data file with so many columns but there we go. I thought over 100 was too many!!