Profiling Details in Viya Data Explorer

[snathju]

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

[LouGalway_sas]

Subhojit,

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

Regards,

Lou

[snathju]

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 · Accepted solution]

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.