Apply filter condition dynamically

[sbatra116]

can't find the solution, i'm sure it has to be simple. 

dataset/table has the filter in a column that needs to be applied to every row.

Apply the filter on days column. both filter and data exists in same table.

condition for first row will look like:  is days >5.  depending upon output the result column should be populated with YES/NO 

same for the other rows.

i was trying to use the dynamic replace but its messing up the result set. 

ID	Days	FIlter	Result
1	10	>5
2	26	>5
3	5	=1

output 

ID	Days	FIlter	Result
1	10	>5	YES
2	26	>5	YES
3	5	=1	NO

[ArtApa]

Hi @sbatra116 - You may do a formula first and then a filter:

[ShankerV]

Hi @sbatra116 

One way of doing this, 

1. Have the input tool with ID and Days

2. Have the formula tool 

Output column - Remane as Filter

Condition 

if ([days]>5)
then ">5"
else "=1"
endif

In the same formula tool, use the + button to create new one.

Output column - Remane as Result

if ([Filter] = ">5")
then "YES"
else "No"
endif

This will fetch the same output you are looking for.

Note: Due to limitations not able to attach the workflow or any screenshot

Let me know if you need any further assistance.

Many thanks

Sharker V

[KrishnaChithrathil · Accepted solution]

Hola @sbatra116 

I tried this way. But I'm sure you'll get better solution than this. 😄

I suggest to update the formula accordingly. 

Good day.