Hello I need to be able to deselect a either a “-1” or a “0” if they appear in the excel column. What is the best way to approach this. I have tried the Filter Table activity but this seems to only filter by selecting certain options, not deselecting them.
Thank you in advance
The Filter Table activity gives you the option to either keep the returned results or remove them
Take a look this one.
I have shared that How to filter the data in Excel . It is very useful to the beginners .
I have the EmployeeData Excel file . I need the to filter only the gender =m.
Before filter the Data :
After Filter the Data :
ExcelFilter.zip (86.4 KB)
Add the filter condition here.
Thank you. Instead of filtering by selecting the “Val1, Val2,” How do I tell it to Deselect an option? The example you showed me Selects an item from the list.
How do I tell the activity to remove them?
Thanks in advance