Dynamically select columns

[mboudlal]

Hey everyone,

I'm new to Alteryx and trying to replicate a task I previously did in SAS. I have a correspondence table that indicates which columns to dynamically import from an input dataset. In SAS, I used this table to select and rename columns, where a certain flag (1 or 0) determined which columns to keep.

How can I achieve the same kind of dynamic column selection and renaming in Alteryx Designer?

Thanks in advance!

[binuacs]

@mboudlal dynamic select tool helps to select the fields dynamically and dynamic rename tool helps to rename the fields dynamically

[CoG · Accepted solution]

Here is a video I put together showcasing the design pattern I use to dynamically select fields based on secondary dataset with keep flag:

https://youtu.be/h5VL62GOT8I

Just as @binuacs said to identify which columns to keep and how to rename them. This workflow should be easily modified to achieve small variations based on specific usecase.

Hope this helps and Happy Solving!

[mboudlal]

Thnk you for this workflow. It acheives the same functionality i was trying to achieve.