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 |
