Column analysis - hard limit of 10 on number of rows output

Highlighted
One Star

Column analysis - hard limit of 10 on number of rows output

I'm running a pattern analysis - I want to discover all distinct patterns in a particular column in my dataset. The dataset has over 130,000 rows. Running manually coded SQL, I can see that the column data exhibits 118 distinct patterns. Running the column analysis in Data Studio only shows 10 result rows - 10 distinct patterns.
How can I get down to all of the discernible patterns? Adjusting the "First n rows" limit from 50 to 999 doesn't seem to affect anything. Being able to assess all of the data in my application is key to my choice of TOS for my DQ purposes. Showing only 10 results out of a possible 118 isn't useful.
Thanks for any help that you can offer,

Phil
Employee

Re: Column analysis - hard limit of 10 on number of rows output

Hi Phil,

there are options in the indicator to display more than the top 10 patterns. Double click on the indicator.
There is also an indicator to show the bottom 10 patterns. That's useful for finding erroneous patterns (which usually don't appear often).
One Star

Re: Column analysis - hard limit of 10 on number of rows output

Hi scorreia,


My apologies, but I searched long and hard for such a setting before posting to ask for help. I have done as you asked, but I cannot see any such setting, either related to a built-in indicator or to the UDI that I built to further investigate this issue.
Please could you clarify further,perhaps by supplying a screenshot?

Many thanks,

Phil

PS Every time I log in with my registered username and then try to post, the forum software loses my log-in and won't allow me to enter my username in this dialog
One Star

Re: Column analysis - hard limit of 10 on number of rows output

It took me a while to correctly interpret your answer. Now that I've done so, I have what I need. Apologies - now resolved. 

Thank you for taking the trouble to answer my initial question.

Phil (aka "barikman" - my Talend username)

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read