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

[ed_b]

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

[danrh · Accepted solution]

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

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.

[ed_b]

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