I have and excel with certain data, i need to check if the columns contains that value and then if they are available, i need to uncheck those options from specific columns.
example : Column Name - “Capability” - Uncheck “Transfer”. If column “capability” contains an option of “Transfer” then i need to uncheck that option during filtering. this has to be performed directly on excel without storing data.
Its easier to manipulate data when its in the bot’s memory, and it is quite cumbersome when you try to automate data through UI, but if that is what you really want then you can use the Filter Table Activity under Excel:
This of course, only works if the dataset is encased within an Excel Table.
Without it, you won’t be able to perform the filtering.
ECC to investigate_9_3_2022.xlsx (186.7 KB)
Please find the sample input. I need to check if “capability” column contains “Transfer”. If it contains then i need to uncheck the “Transfer” filter directly in excel