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
TI load txt file - retrieve incomplete records
-
- 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
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.
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
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
-
- 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
Wim thanks for your reply.
I have resolved the problem during the day, it was a Char Quote causing some data been misread.
I have resolved the problem during the day, it was a Char Quote causing some data been misread.