Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
For limiting number of rows at load time, you may use the First keyword
ModelTable:
First 1000
Load * From ... [your data table];
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.
You may use Dimension Limits tab of the Table properties window for limiting number of rows displayed.
But not for a table box, it appears?
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
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 ?
Ah darn. Alright. Thanks for the information Jonathan!
Yes, but it looks like that's not an option with a Table box