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

Custom IF condition

sbatra116
8 - Asteroid

I'm trying to create a generic solution for all my datasets (50+)

 

Different dataset can have different conditions on which data will be filtered.

instead of writing multiple if/else I'm saving them in a column.

 

Question: can i use my IF condition from dataset into IF condition custom filter ?

 

column (dataset_ID) will refer to the dataset that i'll be using. it will be multiple (50+ in number)

but i'll be running worflow only for one dataset at a time.

 

dataset_IDIF_Condition
1[STATUS] != 'closed'
AND [CLEARED] = 1
2[STATUS] != 'open'

3[CLEARED] = 0

 

3 REPLIES 3
Luke_C
17 - Castor

Hi @sbatra116 

 

Can you share some data with the status and cleared columns?

sbatra116
8 - Asteroid

@Luke_C 

 

sample data1 

 

dataset_idRunning_IDDuedateNameSTATUSclearedtype
1105/20/2023Test1closed1Shoes
1203/04/2019Test2open 0Clothes
1311/04/2022Test3open0sneakers

 

 

sample data2

 

dataset_idRunning_IDDuedateNameSTATUStype
2105/20/2023Test2.1closedShoes
2203/04/2019Test2.2closedClothes
2311/04/2022Test2.3opensneakers

 

ArtApa
Alteryx
Alteryx

Hi @sbatra116 - I hope this idea will work for you:

 

ArtApa_0-1655859393214.png

 

Labels