Hi,
I have 12 different files which pull into a workflow. I need to select certain fields within each file based on the column name. I am using the dynamic select tool. Rather than inputting the field names directly into the formula box of the tool, is there a way to select the field names based on a separate text input file? This way I can link up each dynamic select tool to the text input file (I will have 12 dynamic selects for each of my 12 files) and can change the field names within the text input file based on if they change each month, rather than changing the field names 12 times in the formula boxes of the select tools.
Thanks
Hi @qasdxx
Here is how you can do with help on dynamic rename and dynamic select.
1. Using dynamic rename to set description as keep for required columns.
2. Using dynamic select to keep only columns that have description keep.
3. Using dynamic rename to rename the required columns.
Hope this helps : )