Alteryx Designer Desktop Discussions

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

Checking char(alphabetic) only. in name between spaces getting failed

Nagaraju_kanna
8 - Asteroid

Hi,

 

I am Checking char(alphabetic) only. in name between spaces also getting failed.

 

my requirement 

1. checking length greater than 11 fail

2. if any null values fail

3. if alphanumeric 123abc or abc123 fail

 

please check my workflow

7 REPLIES 7
JosephSerpis
17 - Castor
17 - Castor

Hi @Nagaraju_kanna I mocked up an approach to tackle your requirements.

Qiu
20 - Arcturus
20 - Arcturus

@Nagaraju_kanna 
I think one conditional statement should do if.

0106-Nagaraju_kanna.PNG

atcodedog05
22 - Nova
22 - Nova

Hi @Nagaraju_kanna 

 

Here is my take on it

IF Length([NAME])<= 11 and REGEX_Match([NAME], "\u+") 
Then 'PASS' 
Else 'FAIL' 
Endif

 

If only alphabetic and length less than or equal to 11 then pass rest all fail

 

Workflow:

atcodedog05_0-1641453049808.png

 

Hope this helps : )

Nagaraju_kanna
8 - Asteroid

Hi atcodedog05,

 

I check workflow but 4 and 7 rows fail. It should be pass. because less than 11 char.

atcodedog05
22 - Nova
22 - Nova

Hi @Nagaraju_kanna 

 

You mentioned if it has space if should fail

 

If space is ok here is the workflow

atcodedog05_0-1641464628127.png

 

Hope this helps : )

 

Nagaraju_kanna
8 - Asteroid

Thank you

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Nagaraju_kanna 

Cheers and have a nice day!

Labels