Exporting a Specific Range

Technical Help
1

Hi guys, when I try to export all I can see is ‘Grid’ (the view) or ‘Export Entire Table’

Is there a way where I can export a specific range?

E.g. we have some tables which have hundreds of thousands of records, and I only want to export the first 50,000

2

Hi Emily,

You can do this by creating a new column to your table that contains the id of a row:

  1. Add a new field and name it for example ID (in capitals)
  2. The type of the field is formula and the formula is: row_id()

Now you can create a new view and set a filter to that view. In the filter, you can determine which id’s must be shown. For example: only rows with an id smaller then 50.000. Finally, you can export the view.

Regards
Frederik

1 Like