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: 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 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-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
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