Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Selecting columns based on their column name

nataliad18
8 - Asteroid

So I have column names such as :

 

England      USA         27369        Germany    291      London

 

 

I ONLY want to select the non-numerical column names (note that field types for all of them are numeric, its the actual column names that differ)

Is there a way to do this? Dynamic select seems to only apply to the actual field name and not to actual column name?

 

Thanks!
Natalia

2 REPLIES 2
ShankerV
17 - Castor

Hi @nataliad18 

 

One way of doing this.

 

ShankerV_0-1684830403652.png

 

REGEX_Match([Name], "[a-zA-Z ]+")

 

ShankerV_2-1684830439231.png

 

 

 

 

Input was:

ShankerV_1-1684830423739.png

 

Many thanks

Shanker V

nataliad18
8 - Asteroid

Perfect! Thank you!

Labels
Top Solution Authors