Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to identify records that don't match the other records

camarieschmidt
5 - Atom

I want to be able to identify records that don't look like what I would expect. For example in the reference column the first 5 records are all just a string of 4 characters, but the last record has a character at the end which is not expected.

 

camarieschmidt_0-1666144385117.png

 

3 REPLIES 3
grazitti_sapna
17 - Castor

Hi @camarieschmidt , You can use regex to match the field as per your requirement. Please find below the solution for the use case you have submitted. In case your input is different from what you have submitted please do let me know.

 

grazitti_sapna_0-1666151068588.png

 

Sapna Gupta
ARussell34
8 - Asteroid

Additionally, if it is rather length that is the issue, then can use a formula where If length(reference) = 4 then 1 else 0 endif. This will identify any output that doesn't meet that length of 4 criteria. 

Emmanuel_G
13 - Pulsar

@camarieschmidt 

 

Find in attachement to do that.

 

You can also do that with string functions such as substring or Right to take the last character and check whether or not it is a letter.

 

Emmanuel_G_0-1666257537015.png

 

Labels
Top Solution Authors