SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Profiling Details in Viya Data Explorer

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Profiling Details in Viya Data Explorer

Hi , 

 

In the profile section of the data explorer I can see a particular column called "Pattern Count". Can anyone please help me understand the meaning of that column.

 

Thanks and Regards

Subhojit


Accepted Solutions
Solution
‎04-11-2018 10:19 AM
Occasional Contributor
Posts: 14

Re: Profiling Details in Viya Data Explorer

In your example that would only be one pattern count (length one, lower case). Think of a field containing state with the following content:

 

NY, ny, New York, new york

 

This field have four patterns, if you only expect the field to have a two letters (upper case), you can quickly see that you have a data quality issue.

View solution in original post


All Replies
SAS Employee
Posts: 9

Re: Profiling Details in Viya Data Explorer

Subhojit,

 

Pattern count is the number of different distinct patterns in the column.

 

Regards,

 

Lou

New Contributor
Posts: 2

Re: Profiling Details in Viya Data Explorer

Posted in reply to LouGalway_sas
Could you please explain in a bit more details .

Say I have a table of 10 records , and a particular column of that table
has the following entries:

a , b, c, a , c ,b, a, b, b, c

what will be the pattern count for this

Thanks and regards
Subhojit
Solution
‎04-11-2018 10:19 AM
Occasional Contributor
Posts: 14

Re: Profiling Details in Viya Data Explorer

In your example that would only be one pattern count (length one, lower case). Think of a field containing state with the following content:

 

NY, ny, New York, new york

 

This field have four patterns, if you only expect the field to have a two letters (upper case), you can quickly see that you have a data quality issue.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 124 views
  • 0 likes
  • 3 in conversation