Filter tool used on a field postion in dataset not on field name

[chvizda]

Hi all

I want to filter my data by 2 different fields. 

I know the name of the 1st field. But the name, of the second field can be different from day to day. But I know, it is everytime the following field of the the 1st one.

Dataset 1:

Field_1,Field2,Field_hardcoded,field_z_xxx,Field3,Field4

Dataset 2:

Field_1,Field_hardcoded,field_y_zzz,Field5,Field7

Is there a way to to set up a formula to specify to use the following field of Field_hardcoded.

Many thanks

Steffen

[MarqueeCrew · Accepted solution]

Hi @chvizda,

Here's how I suggest to approach this question:

1. Figure out the field name
2. Switch the found name to a Fixed Name
3. Apply the filter using the Fixed Name
4. Switch the Fixed Name back to the original name

For my data, this works.

Cheers,

Mark