Free Trial

Alteryx Designer Desktop Discussions

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

i want to create a filter to check if all the values in the colunm are in upper case

Raj
16 - Nebula

how to use the filter tool to check if all the values in the column are in upper case

example- ABC
Acdcf

xyz

ref

earth

TEST

 

i want to apply filter and T anchor should show - TEST and ABC while F contains rest of the values.

11 REPLIES 11
caltang
17 - Castor
17 - Castor

Sorry - I am outside, can't help much. @binuacs can you help @Raj ?

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
binuacs
21 - Polaris

@Raj 

REGEX_Match([F1], "^(?:[A-Z][^\s]*\s?)+$",0)

image.png

Labels
Top Solution Authors