How to remove the first line in a pivot table

Learning & Development Programs Automation Starter
1

In a pivot table how can we remove the first line in a table

2

Hi @sandhyareddy ,

Can you please explain what is actually needed with a example or screenshot to help you with the exact solution.

Regards,
Rohith

3

Hi @sandhyareddy

Can you share the screenshot and explain bit more about your query

Regards
Gokul

4

Hello,

you want to remove the data from the pivot itself? Like the headers? please be more specific,
to my knowledge you can´t remove a row from the pivot itself, unless you remove it from the datasource.

Best Regards
Lukas

5

Screenshot (166)
Screenshot (166)1920×1080 141 KB

In the attached screenshot i want to remove first row i.e count of environment using uipath

6

Screenshot (166)
Screenshot (166)1920×1080 141 KB

In the attached screenshot in the pivot table, i want to remove first row i.e count of environment

7

here i attached screenshot

8

Hello,

you could hide it or filter it, if you truly want to remove it, you would have to remove it from the data source (to my knowledge).

Best Regards

9

Hi @sandhyareddy

After the Pivot created, We can use Read range activity → Store it as Dt

Use Delete row activity and Delete the first row.

Regards
Gokul

10

For Reference @sandhyareddy

image
image863×411 13 KB

11

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