Multiple Selection

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!

Datasets

Accepted answers

clmc9601

Hi @mcarvalho,

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

All comments

apathetichell

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

clmc9601

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. 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703