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 |
Solved! Go to Solution.
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
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.