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.
Alteryx rookie here! Just started using the tool and am amazed at its power already!
I have a huge data set with over 500 columns, of which I only really need 30 or so for my analysis. Instead of using the select tool and manually scrolling through 500 fields to choose the 30 I need, I was wondering if there is a way to use a list of the 30 columns from a separate excel file, and then use this list in combination with the select tool.
One method is to list the fields out that you'd want (e.g. in a text input); if you transpose your data, you can use a join as a 'select', where the middle of the join (field name to name, shown below) becomes the fields you want.
To get your data back to where you want you just need to cross tab back. Something along the lines of this (and attached):