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

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

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

Highlighted
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