TI load txt file - retrieve incomplete records

Post Reply
danz
Posts: 6
Joined: Mon Jun 10, 2019 2:47 am
OLAP Product: TM1
Version: PA2
Excel Version: Office365

TI load txt file - retrieve incomplete records

Post by danz »

Hi all

I have a txt file generated from SAP (Encording UTF-8-BOM), open in Notepad++ shows there are 2.4m lines (3 columns, Tab delimited).

Try to read it with TI and to count number of records, I get 1.4m+.

Where is the other 1m records????

Anyone come across similar issue before????

Appreciate if you could share your view.

PA 2.0.6
Wim Gielis
MVP
Posts: 3113
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TI load txt file - retrieve incomplete records

Post by Wim Gielis »

How do you count in TI ?
Please show us the code.
Also know that completely empty lines will not enter the metadata and data tabs.
Best regards,

Wim Gielis

IBM Champion 2024
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
danz
Posts: 6
Joined: Mon Jun 10, 2019 2:47 am
OLAP Product: TM1
Version: PA2
Excel Version: Office365

Re: TI load txt file - retrieve incomplete records

Post by danz »

Wim thanks for your reply.

I have resolved the problem during the day, it was a Char Quote causing some data been misread.
Post Reply