How to see more rows than the first 1000 rows in Data Viewer?

Follow

Pauli Ekonen

• January 06, 2017 16:40

Hi,

 

How can I  see all rows (when over 1000 rows are in question) in Data Viewer?

 

In Bre I just needed to right click on the wanted output and choose Data Viewers (all). However I couldn't find this feature in Dataverse. How can I see all line items in Data Viewer if there are more than 1000 lines in output? In most of my data flows the data is way more than 1000 rows.

 

Best regards,

 

Pauli

0

• 

  Adrian Williams

  • January 06, 2017 16:56

  Hi Pauli,

  the current release of Dataverse only enables the first 1000 records to be displayed in the Data Viewer, It is a roadmap candidate to offer mechanisms to view more than 1000 records in the Data Viewer.

  You can currently use the 'Export to CSV' menu item on the right side of the Data Viewer to export all the data in the data set of the selected tab to a file.

  

  Regards,

  Adrian

   

  0

  Comment actions Permalink
• 

  Stony Smith

  • January 06, 2017 17:01

  Here's a trick for you: If you simply want to review the records 1000-1999, then add a HEAD node and configure it for 2000 records, and send that output to a TAIL node set for 1000.   That will give you the second block of records.

  0

  Comment actions Permalink
• 

  Adrian Williams

  • July 28, 2020 11:41
  • Edited

  From Data360 Analyze v.3.4.3 you can set the maximum number of records that are displayed in the Data Viewer:

   

  A system property has been added that you can use to define the number of records that are displayed in the Data Viewer. Previously, the data viewer displayed a maximum of 1000 records.
  To configure the property, add the following line to your cust.prop file, replacing <records> with the required value:
  
  ls.lae.dataviewer.pageSize=<records>
  
  The value will be applied to all users. The maximum value is 20 000. If you enter a value greater than 20 000, the first 20 000 records will be displayed.

   

  See this article for details of the system property files.

  https://support.infogix.com/hc/en-us/articles/360048214134-Data360-Analyze-prop-files-explained

  0

  Comment actions Permalink

Please sign in to leave a comment.