Create IF condition using the below 2 columns (column 1 and column 3).
condition: (Age_Business_Days > 0)
then use this condition to filter data.
thank you
Hi @sbatra116!
Will you please provide more details or a sample of your data?
A formula like this might work in the Filter tool, depending on the structure of your data:
[AgeCondition] > 0
Can't really tell too much about the requirement because of the lack of detail in your post. However, if this condition has a need to change dynamically then you may want to explore the dynamic replace tool. I've attached a small sample workflow and you would simply add a filter afterwards to remove nulls:
My bad. I should have written more detail. @DataNath @ddiesel
Update ---
Spreadsheet data
Now the condition are stored in a different source (can be spreadsheet or db table)
In order to filter the spreadsheet data ; i'll be creating condition run time using column 1 and column 3 from the second table.
if the second source gets updated, my condition should automatically update in the workflow depending upon the columns mentioned in second table.
@sbatra116 One way of doing this with the help of dynamic replace tool
Let's give this a try...
Is the operator in the condition always "greater than"? If there are other operators such as "less than" or "equal", we will need to add a bit more logic.
Please let us know if this works.
Thanks,Deb
Hi binuacs
Like the way you used the dynamic replace tool. But i'm not getting the result i want.
condition
result should be
