You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-08-02 16:21:54

rlmagidson
Member
19 posts

rlmagidson said:

How to set number of rows for View Values and View Rows

Hello 
Using TOS_DQ 6.2.1.20160704_1411, on the Analysis Results tab - Simple Statistics.
Right-clicking on a Distinct, Unique, or Duplicate Count and selecting View Values/Rows, only 50 are being returned. The only place I see to set row limits is on the Analysis Settings tab (which effects the preview) and in Window -> Preferences -> Talend (also preview).
My question is where do I set the number to be above 50 in order to view and export all of the Distinct/Unique/Duplicate data?
Many thanks for the help
- Russell

Offline

#2 2016-08-08 10:57:31

xdshi
Talend Team


xdshi said:

Re: How to set number of rows for View Values and View Rows

Hi,
Do you want to increase the number of displayed values in Data Quality analysis?
Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2016-08-08 14:04:07

rlmagidson
Member
19 posts

rlmagidson said:

Re: How to set number of rows for View Values and View Rows

Hello Sabrina - I need to view and/or export all of the data, not just 50 rows. I just don't see how to change the value of 50.

Thank you
- Russell

Offline

#4 2016-08-09 20:15:58

rlmagidson
Member
19 posts

rlmagidson said:

Re: How to set number of rows for View Values and View Rows

I see that there is a difference between using delimited files and sql tables... with the sql table I have a "limit rows" option when viewing data, while no such option exists when viewing data from files.

- rlm

Offline

#5 2016-10-06 11:30:17

matt.schroeder
Member
2 posts

matt.schroeder said:

Re: How to set number of rows for View Values and View Rows

I'm able to change the limit for the number of rows to export and I'm using a delimited file. However, the limit can only be 3 digits, so the max is 999.
You change it on the data preview settings when you first go to run your analysis.
mini_blob.png
-Matt

Last edited by matt.schroeder (2016-10-06 12:39:51)

Offline

#6 2016-10-06 11:54:17

matt.schroeder
Member
2 posts

matt.schroeder said:

Re: How to set number of rows for View Values and View Rows

Sorry, ignore my last post. That is just for the preview. You can change the amount of rows to export by going into the analysis parameters and changing the 'max number of row kept per indicator'.
mini_blob_20161006-0354.png

Last edited by matt.schroeder (2016-10-06 12:38:30)

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy