Select Top Records

TopRecords operation should be used only when you want to extract the specific number of rows starting from the topmost row of the data in the DataModel.

Note that when you use the TopRecords operation on a DataModel, it will generate a new DataModel with only the selected rows of the data.

Let's take a basic example of a tabular data shown below:

Order Date Country Sales Quantity Shipping Cost
1/22/2011 Australia 59.724 6 27.43
1/22/2011 United States 125.248 3 3.64
1/22/2011 Australia 6.318 1 1.77
1/24/2011 Australia 110.808 3 9.92
1/24/2011 United States 40.08 6 4.31
1/24/2011 India 59.25 5 4.27
1/24/2011 United States 5.94 3 0.95
1/26/2011 India 79.38 3 13.82
1/26/2011 India 342.51 7 13.22

In the above tabular data, TopRecords operation is applied as shown below:

DataModel newModel = model.TopRecords(5);

The output after applying TopRecords operation is shown below:

Order Date Country Sales Quantity Shipping Cost
1/22/2011 Australia 59.724 6 27.43
1/22/2011 United States 125.248 3 3.64
1/22/2011 Australia 6.318 1 1.77
1/24/2011 Australia 110.808 3 9.92
1/24/2011 United States 40.08 6 4.31
Was this article helpful to you ?