Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

chvizda
8 - Asteroid

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

 

 

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

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

Capture.PNG

For my data, this works.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels