Filter Pivot Table in uipath

Learning & Development Programs Reboot Your Skills 2021
1

Hi friends! I need to filter the pivot table for each of its rows, but I have a number of problems:

  1. When filtering lines that contain several elements, only the first part is copied, and the rest for some reason is ignored by the robot
    image

  2. When filtering, I use for each row, I need to skip empty rows and take elements only where there are values, and ignore empty ones
    image

I would be grateful for any help

2

@asiljan.7,

Can you try filtering with Filter Pivot Table activity?
it will ask you Pivot name, sheet name and excel name.

3

it works, I put it in for each row and instructed it to filter the first column as row (0) .tostring, but there is a question:

  1. It does not store filtered values
  2. What about empty rows in a column during filtering?
    image
    image400×787 16.5 KB
4

@asiljan.7,

Is it possible to send pivot table file? i could try.
OR
You can print rows from datatable(io) that contains.

5

I apologize for the late reply, everything works, thanks a lot!

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.