Custom IF condition

[sbatra116]

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_ID	IF_Condition
1	[STATUS] != 'closed' AND [CLEARED] = 1
2	[STATUS] != 'open'
3	[CLEARED] = 0

[Luke_C]

Hi @sbatra116 

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

[sbatra116]

@Luke_C 

sample data1 

dataset_id	Running_ID	Duedate	Name	STATUS	cleared	type
1	1	05/20/2023	Test1	closed	1	Shoes
1	2	03/04/2019	Test2	open	0	Clothes
1	3	11/04/2022	Test3	open	0	sneakers

sample data2

dataset_id	Running_ID	Duedate	Name	STATUS	type
2	1	05/20/2023	Test2.1	closed	Shoes
2	2	03/04/2019	Test2.2	closed	Clothes
2	3	11/04/2022	Test2.3	open	sneakers

[ArtApa · Accepted solution]

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