This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.