Dynamically select columns based on another table value

[alpro-23]

Hi all,

I'm new to Alteryx and I am still picking up how to do a simple workflow.

I am hoping to automatically select columns based on another table's value (Hence, 1 Master Table and 1 Supplementary Table). 

My use case is that I have filtered through certain columns that have substantial information (using summation tool etc.) and I would like to automatically select them from the master table for investigative purposes.

Below is an example of what I'm trying to achieve. I can't use Select tool as that is 'manual'. Dynamic select doesn't seem right as it only accepts a single input.

Would appreciate any help!!

Master Table Columns: 

Supplementary Table:

[mattnason1 · Accepted solution]

Here's how I did it.

[ChrisTX · Accepted solution]

I used Dynamic Rename to add a temporary prefix "keep_" to the field names that should be kept

Then use Dynamic Select with a formula

StartsWith([Name], "keep_")

Then another Dynamic Rename to remove the temporary prefix

Chris