Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Add List-Based Mode to Dynamic Select

A seemingly minor task that has popped up several times on my team is the ability to select a subset of columns using an input list.  Different people have achieved this in different ways (transpose/join/cross-tab, dynamic rename/select), but it seems like a common enough task to warrant a single-tool solution. 

 

R has a simple way to do this:

# create a vector of the columns we would like to select
columns <- c("column_b", "column_d")

# subset based on the column names we defined in our "columns" vector
df_subset <- df[columns]

 

We have built a macro to achieve this (attached), but I would love if there was a second input anchor on the Dynamic Select tool, with list-based select mode as an option in the dropdown.  

 

The macro currently has a minor annoyance, where the user gets a "RecordInfo::CreateRecord" error presented on their palette when they choose the "Keep Columns in List" entry.  This error goes away with a run or an F5 refresh, but if anyone has a suggestion for getting rid of this, it would also be appreciated.

4 Comments
5 - Atom

Hi - 

Thank you for sharing this macro; I too would benefit from being able to feed a list into the Dynamic Select tool.  I have a main output with 400+ fields, of which I only need 100-200 at a time.  It would be nice to have the ability to update an Excel file of what I want so that I can more easily re-run without having to manually go through a select tool and check/uncheck fields.

8 - Asteroid

 

 

a second input anchor on the Dynamic Select tool, with list-based select mode as an option in the dropdown.

 

Yes, please

8 - Asteroid

+1!

6 - Meteoroid

" a second input anchor on the Dynamic Select tool, with list-based select mode as an option in the dropdown." 

 

^ Yes, please. We'd very much like that.