Hi community,
I need to extract specific fields from the original dataset based on a "Field List." For example, Table 1 requires fields B, C, D; Table 2 requires fields E, F; and Table 4 needs to rename certain columns before selecting them.
In essence, I want to create a dynamic version of the Select tool using a mapping table. I'm currently using the Dynamic Rename and Dynamic Select tools, but the mapping isn't ideal. Here are some issues and restrictions:
1. Using only Dynamic Rename tool results in incorrect renaming, like A_2.
2. Everything needs to be dynamic so that entering a table name will produce the correct table content.
3. I tried using the Cross Tab tool, but it changes parentheses () to underscores _.
How can I resolve these issues?
