How to select specific columns

[Learner09]

Hello All,

In my Alteryx workflow, I have an excel spreadsheet (Input Data) that contains approx. 26k lines/ rows with 350 columns but I need some specific columns for my analysis - around 100 columns out of 350 in a specific order. Is there any way I can pull only100 columns that I need in a specific order, or do I need to arrange and select manually? Please guide.

Thanks,

[SeanAdams]

Hey @Learner09 If you know the column names that you want to keep - you can put these into a static table (text input), and then use the dynamic select tool to select these dynamically.

This is a nice way of doing things because you can change the column names that you want fairly easily, and you can make this consistent across your flow without having to reconfigure a bunch of Select tools

[Puneet13]

HI Nebula can you tell me how to do it with your first sugggestion