Multiple Selection

[mcarvalho]

Hi all,

I have to select about 100 fields in a database that has more than 6000 fields.

Is there any way that I combine a list of the fields that I want to select with the fields in the database automatically? Instead of having to find each specific field? 

Thanks for the help!

M.

[apathetichell]

Transpose both so the field name is now in the [name] column and do a join on [name]

[clmc9601 · Accepted solution]

Hi @mcarvalho,

Philip's solution here is one of my favorite solutions I've seen for this use case. I hope this helps!

[apathetichell]

@clmc9601  Always great to see Dynamic Select make an appearance.

[mcarvalho]

Thanks all! I really liked the Dynamic Select solution. It's the one that I used.

[clmc9601]

Hi @mcarvalho, I'm so glad it helped! Could you please mark one of these posts as a solution? It helps other users navigate the community and find answers, and it helps incentivize people to write solutions.  🙂