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

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

Dynamic Select.yxmd