Automatic Dynamic Selection

[isayev_alex156]

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.

[jdunkerley79 · Accepted solution]

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]

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.