Formula:
If a record does not contain 10 digits, make the record Null; otherwise, keep the original value
Data Cleansing:
Remove punctuation ( ) - from phone numbers
001
5124856551
002
(805)241-1904
003
805402919
004
(650)390-9955
005
8024997434
006
5128207851
007
5128207436
008
(818)29268888
009
3124917815
010
3234058801
"Phone Number"
False
False
True
False
False
False
False
True
False
upper
Valid Numbers=if Length([Phone Number]) !=10 then Null() else...
C:\ProgramData\Alteryx\Engine\Engine_5600_74b9f6ffae5c415b8df301eb231cf8d8_\Engine_7152_cbc9c6348c9b4eb3a5683b6ae36292dc_.yxdb
Horizontal
Insert_Null_Value