I am using Studio X
Hi everyone I am using the excel pivot filter and I can’t find a way to uncheck the blank data in pivot beside using clicking is there a another possible way to uncheck the blank data in pivot filter??
Did you happen to try this?
https://docs.uipath.com/activities/other/latest/productivity/filter-pivot-table-x
Try with Type.Missing
in the filter
Cheers
do you have sample vb expression for this?
this is hoe it looks…
as pivot does not have not equals you can filter on all the values in required column leaving blank
cheers
Hello @flashdrive07
-
Add “Set Filter” Activity to your StudioX workflow.
-
Configure the “Set Filter” Activity:
- Indicate the pivot filter you want to modify by selecting it in Excel.
- Choose the filter criteria (e.g., “equals” or “does not equal”).
- Set the filter value to “blank” or specify the value you want to exclude.
-
Run your StudioX workflow.
-
The “Set Filter” activity will programmatically uncheck the blank data in the pivot filter.
Thanks & Cheers!!!
this is the sample image of pivot filter “does not equal to is not available in pivot filter”
@Anil_G
Hi sorry for the late notice…
I already tried it but it checks the current row.
displays the data per current row.
the automation must uncheck the “blank” in the pivot filter.
If you dont clear the filter and use for each row ideally it should check all the data and not inly one
Can you please confirm the same
Cheers
@Anil_G
this is the output of the filter
Hi, did you manage to solve the problem? I have something similar that bothers me. after filtering the pivot table where only one data is enough, I was left with a column named blank that I don’t want there.
no,… I just used click and shortcut keys to uncheck the blank column
yes, that’s a possibility. but will it then be possible to start this automation on unattended? I would also use a simple click, but this put me off.