Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Automatic Dynamic Selection

isayev_alex156
7 - Meteor

Hello,

 

I have a field in a dataset, where the rows should correspond to the columns in another dataset.  I want to automatically match and keep all of the items from the rows in dataset 1 that are in dataset 2.  Anyone know of a way to automattically, dynamically select fields in a manner that yields the result below?

 

Dataset 1:

 

Item:

001

002

003

 

Dataset 2:

 

001   002   003   004   005

 

Result:

 

001  002  003  

 

This is greatly appreciated.  Thank you in advance.

 

 

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

You can do this in as a two step process using a dynamic rename and dynamic select.

 

Basically put a flag into the description and use this for the dynamic select.

 

If you need to reset the description afterwards you can do this using a field info tool.

 

Attached simple demo

jdunkerley79
ACE Emeritus
ACE Emeritus

Created a macro version and published to the gallery https://gallery.alteryx.com/#!app/Dynamic-Select/570973f6aa690a17d425aecd.

 

It resets the description back to the input as well now.

Labels