Limit data to 10000 rows in straight table

[ashishp]

Hi There 

We want to show always 10,000 rows in straight table without using any extension. 

Can it be possible? 

I have used following in the Data Handling settings on Staight table , 

1. Count(filedname)<=10000

2. Rowno(TOTAL)<=10000 

Nothing is working , can you please suggest? 

Thanks in advance. 

[BrunPierre]

Maybe this

Script:

Load *,

Rowno() as NumberOfRows

From Table;

Expression: Count({<NumberOfRows={"<=10000"}>}YourMeasure)

[ashishp]

Thanks Peter. 

This is not satisfying the 10000 record display in the table, 

Where to use folowing condition? 

Expression: Count({<NumberOfRows={"<=10000"}>}YourMeasure)

[ashishp]

Expression: Count({<NumberOfRows={"<=10000"}>}YourMeasure)

[deepanshuSh]

Hi @ashishp, you need to use it on the front end in the table where you are trying to calculate the measure. What Peter suggested is actually working and I have used it before as well. It is a set analysis. 

[BrunPierre]

On second thought, considering the data volume my suggestion would solely be at the back end.

For the expression I just changed yours "Count(filedname)<=10000" into a set analysis expression to illustrate by example the row filtering.

Nonetheless, a more practical approach maybe is to do this;

Script:

Load *,

RecNo() as Sno,
RowNo() as Rownum

Resident Transact    //Transact is an already loaded table.

where Sno <= 10000

Order By Sno desc ;   

[ashishp]

Hi

@BrunPierre @deepanshuSh 

Thanks for quick response, 

When I use below condition in Table as expression its working fine.

Count({<NumberOfRows={"<=10000"}>}YourMeasure)

However when I select any filters due to above condition table is showing blank data , without any rows. 

[BrunPierre]

Could you share a sample of your data, and what you hope to achieve.

[ashishp]

@BrunPierre 

I have 5 filters in my report. 

When I use above expression the data shows in Table. 

Upon applying any one of the filter the table shows no data. 

That means above expression is not working when we apply filters. 

[Timario]

Hi. May be you load in script only 10000 rows?
First 10000 Load * from source;

[ashishp]

@Timario  this will not work, as we are filterring data from 5 regions. if we use First 10000 Load * from source; 

Other region data will never show.