community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How to extract columns that contain a prefix e.g. 'Test-'

Meteor

Hi,

 

I am new to Alteryx. As indicated in a previous post, unless I am mistaken, it appears to lack some basic functionality. How does one extract columns containing a particular string? I wish to extract only these and sum along the columns axis in order to set as a new field.

 

Ed

Pulsar

You should be able to do this using the Dynamic Select tool.  Something more or less like this:

 

image.png

 

 

Replace 'Test-' in the Expression with whatever string you're looking for.  In this instance, any field with the term 'Test-' in the field name will be extracted.  To sum up the columns after this, add a Summarize tool and choose sum as your method of aggregation.

Meteor

Very kind danrh, this looks like what I was looking for!

Labels