Hello -
I'm new to TM1 and hope someone will help me.
After reading a csv file which has 100 rows, i need to preview all the 100 rows when i hit on preview button. How to increase the number preview rows from default of 10 to 100.
Please advice.
Thank you!
Preview rows in turbo Integrator
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Preview rows in turbo Integrator
You can't. The purpose of a preview is just that. It lets you check that the data that you're going to get is the type of data that you're expecting to get so that you can write the correct code. It's not intended to be a data viewing facility.smantrip wrote: I'm new to TM1 and hope someone will help me.
After reading a csv file which has 100 rows, i need to preview all the 100 rows when i hit on preview button. How to increase the number preview rows from default of 10 to 100.
Please advice.
If you want to do that you'd be better off doing it in the tool that's designed to do it; Management Studio for SQL Server, TOAD for Oracle, even MS Query from inside Excel if it comes to that.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
smantrip
- Posts: 7
- Joined: Sat Apr 26, 2014 6:57 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2010
Re: Preview rows in turbo Integrator
Thank you alan - you are the best and quick in response..
-
BariAbdul
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Re: Preview rows in turbo Integrator
He is indeed the best,quite a legend!smantrip wrote:Thank you alan - you are the best and quick in response..
"You Never Fail Until You Stop Trying......"
-
Wim Gielis
- MVP
- Posts: 3241
- 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: Preview rows in turbo Integrator
If I'm not mistaken (it's been a while since I used the tool), Performance Modeler shows more rows in the Preview.
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
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