Page 1 of 1
Preview rows in turbo Integrator
Posted: Sat Apr 26, 2014 7:08 am
by smantrip
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!
Re: Preview rows in turbo Integrator
Posted: Sat Apr 26, 2014 7:12 am
by Alan Kirk
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.
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.
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.
Re: Preview rows in turbo Integrator
Posted: Sat Apr 26, 2014 7:17 am
by smantrip
Thank you alan - you are the best and quick in response..
Re: Preview rows in turbo Integrator
Posted: Sat Apr 26, 2014 1:36 pm
by BariAbdul
smantrip wrote:Thank you alan - you are the best and quick in response..
He is indeed the best,quite a legend!
Re: Preview rows in turbo Integrator
Posted: Sun Apr 27, 2014 1:16 pm
by Wim Gielis
If I'm not mistaken (it's been a while since I used the tool), Performance Modeler shows more rows in the Preview.