Refine Non-Standard Blank Values Data Hygiene Test #10
Replies: 3 comments
-
|
I found a similar, but different example: I have distinct values in my column: 00, 01, all the way up to 12, but the 00 is getting flagged as a NSBV. |
Beta Was this translation helpful? Give feedback.
-
|
Yeah, I agree 99%. What functional data type are you getting for those columns? This might help distinguish valid values. |
Beta Was this translation helpful? Give feedback.
-
|
For the first example, The physical table is VARCHAR(100) (Dataype Suggestion is the same). The Functional Data Type is 'ID-Unique'. For the seconds one, |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
-
I see that the Non-Standard Blank Values Anomaly is sometimes too sensitive. I have a column of type BIGINT that has an incrementing ID in it. The Non-Standard Blank Values test is picking up 99, 999, 999999, 9999999 as being Blank Values. It's simple enough to Mute the Anomaly, but a nice to have is to not flag it in the first place. The values in the column are 100% filled and mostly continuous.
Beta Was this translation helpful? Give feedback.
All reactions