Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Dynamically select columns based on another table value

alpro-23
7 - Meteor

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: 

alpro-23_0-1619448461019.png

 

 

Supplementary Table:

alpro-23_1-1619448482187.png

 

 

 

2 REPLIES 2
mattnason1
9 - Comet

Here's how I did it.

ChrisTX
14 - Magnetar

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

 

ChrisTX_0-1619546712898.png

 

 

Chris

Labels