Solved: Re: Profiling Details in Viya Data Explorer

snathju · Posted 04-10-2018 12:01 PM

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

Erik_Zencos · Posted 04-11-2018 09:47 AM

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

LouGalway_sas · Posted 04-10-2018 12:10 PM

Subhojit,

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

Regards,

Lou

snathju · Posted 04-10-2018 12:18 PM

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

Erik_Zencos · Posted 04-11-2018 09:47 AM

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.