Limit number of displayed rows in a table?

[#1]

Is there a way to limit the number of rows loaded/displayed in a table?  Right now I have a massive table that I would like to neck down to 1000 rows instead of the full 1.5m rows that it's trying to load by default.  Thanks!

[nagaiank]

For limiting number of rows at load time, you may use the First keyword

ModelTable:

First 1000

Load * From ... [your data table];

[#3]

Ah, I think I need to clarify - I mean limit the number of rows displayed in a table object, not a data table generated in my load script.

[nagaiank]

You may use Dimension Limits tab of the Table properties window for limiting number of rows displayed.

[#5]

Hi,

Have a look at the attached link.

Paging Implementation for Straight table

Hope it helps!!

Kiru

[#6]

But not for a table box, it appears?

[JonnyPoole · Accepted solution]

not with a table box.  best you can do is set a calculation condition or show/hide condition on the layout tab on whether to show or not depending if the user has > 1000 rows in their selection.

If you have a unique identifier for the row.   it would be an expression like this   getpossiblecount( [UniqueIdentifier]) <= 1000

[#8]

In the chart Properties --> Presentation tab , there is a checkbox Max Number(1-100). It denotes maximum no. of rows to be displayed.

Is that what you've been looking for ?

[#9]

Ah darn.  Alright.  Thanks for the information Jonathan!

[#10]

Yes, but it looks like that's not an option with a Table box