TI Datasource Behaviour Query

Post Reply
MarenC
Regular Participant
Posts: 436
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

TI Datasource Behaviour Query

Post by MarenC »

Hi,

I was wondering what happens if I create a process with datasource as a txt file, and tab delimited.

In the prolog I set the DatasourceNameForServer = FilePath | File

But then imagine that for whatever reason the source file changes to a comma separated file.

I would expect the process to fall over because all the data would now be in one column, because the process is set to tab but the source
is comma separated.

The thing is, it doesn't appear to work like this, it appears to recognise it is now comma and not tab.

Is this expected behaviour?

Maren
Wim Gielis
MVP
Posts: 3234
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TI Datasource Behaviour Query

Post by Wim Gielis »

Indeed. It will continue to process the file and all contents of 1 line will appear in your first variable.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply