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-10-25 17:01:32

Phil J
Guest

Phil J said:

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

Tags: [mysql]

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

#2 2016-10-26 11:46:53

scorreia
Talend Team


scorreia said:

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).


Thank you for your support,
Sebastiao Correia.

Offline

#3 2016-10-27 17:06:40

Phil J
Guest

Phil J said:

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

#4 2016-10-27 17:35:04

Phil J
Guest

Phil J said:

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)

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy