Dynamic Select to Filter Fields

Hello,

I am trying to filter out certain fields based on their position (e.g. selecting every field EXCEPT the 4th and 5th fields). These fields are always in the same position but sometimes named differently from my source data. I was thinking a dynamic select tool would work and I would do something like the following:

[FieldNumber]!=4 || [FieldNumber]!=5

When I do this, I am just getting an error. Is there a workaround or another solution for this?

Thanks!

Help

Accepted answers

TylerNa

Works for me with this configuration in place. I think you had an OR in place when you needed an AND.

Dynamic Select.png

All comments

EddieW

Hi @ChristopherFunnell,

Thank you for the post! What about using the combination of 'Record ID' and 'Filter' tools? You can then use a 'Select' tool to deselect the 'RecordId' field.

Hope this helps!

ChristopherFunnell

Hi Eddie,

That would work if I needed to identify a specific record, but I need to identify a specific field. Unless I am missing something...

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703