ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

Transforming

Suryachoppakatla
7 - Meteor

Hello Experts,

 

I need a help with regard to achiever "Valid or Invalid" result

 

Filers GIIN field is a combination of "Alpha + Numeric + Special character" like the one shown below and it should be (19 character length)

 

1CSJ3C.99999.SL.136

 

I wanted to write a formula where if there is any change in this format then should result as "Invalid" Else "Valid". IMP NOTE: This format is case sensitive

 

I tried "Length" formula, but do not meet the purpose of this specific format

 

Regards,

Surya

 

1 REPLY 1
MilindG
12 - Quasar