How to query out certain fields (columns) from a feature class using a query

BulkAttributeRemover seems to be working with a regular expression. If you are not familiar with those you can also try the AttributeKeeper which is lighter compared to AttributeManager.

If it still crashes, you could also try to do in steps -and not all at once- and work your way towards the final result.

Hope this helps :)

Use a BulkAttributeKeeper, it's a custom transformer which simply inverts the BulkAttributeRemover.

Then for regex queries I always check GPT4, it gives this, which looks right to me:

^(F[1-9]|F1[0-9]|F[2-3][0-9]|F40)$

And it gives a description of what that is: https://chat.openai.com/share/949c8b6d-9d01-4e20-893a-9de094969000

Hi Chrisnovak

i am quite surprised by the number of fields you have in the gdb. The max number of fields you can have in personal gdb is 255, unless you are using an SDE or other database. Maybe that causes the crash?

There are quite a few transformers that can handle attributes, if the number of the attributes you want to keep is less than the ones to be removed, the easier to use an Attribute keeper. you could also use the Bulk Attribute remover writing an expression for example isolating the 2 first digits not to be larger that 40 but this could be tricky.

This regex should work in a BulkAttributeRemover

^F[4][1-9]$|^F[5-9][0-9]$|^F[0-9]{3,4}$

But an AttributeKeeper would probably work just as well

I find the AttributeManager performance pretty poor in general