Dynamically Select Through Mapping Table

[Zona]

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?

[Zona]

@apathetichell Sorry I was kinda confused, now I'm good. I do need to accomplish both activities. I've understood the solution for Activity 2, and thanks a lot to your response!