Create pivot table by choosing rows and columns

Help Activities
1

Hi Team,

How to create pivot table in excel by choosing rows and column.
Please help me with the solution.

Thanks,
Riya S

2

@Riya_Sharma

Use Create Pivot Table activity.

3

Hi @lakshman ,
But with the help of this activity we can’t choose rows and column name.

4

Hello @Riya_Sharma

You can do that do that using the modern Create Pivot table activity.
Please watch the below video.

5

Hi @Rahul_Unnikrishnan ,

Modern activities is not installed in my UiPath.
Is there any other way to create a pivot table by choosing rows and column.

Thanks,
Riya S

6

@Riya_Sharma you can enable the modern acitivyt from the filter panel. Or you can convert your current project to a modern desigh

Got to project settings and enable modern design.

Else go to filter panel and select modern activities.

7

when set to classic design you also can use modern activities when adpting the activity filter:
grafik

8

Hi @Rahul_Unnikrishnan ,
Unable to find this option under activities.
Can you guide me is there any other way to find it?

Thanks,
Riya S

9

maybe it is shown under another name. Just show us what filter options are offered

10

Hi @Riya_Sharma

Right click on the project and go to settings. Then enable use modern design.
Then you will able to see the modern acitvities.

11

16528695921265891726355041571669
165286959212658917263550415716691920×2560 671 KB

I have only these options in my UiPath

12

Could it be the case that you are using an older UiPath Studio Version (20.X) and/or that an older Excel Package is referenced?

13

Hi @Rahul_Unnikrishnan ,

There is no option to enable the modern design in my UiPath.

Thanks,
Riya S

14

@Riya_Sharma it would be better if you can share the screenshot and whats the studio version ?

15

@Riya_Sharma , Can you send us the sample excel file and sample pivot table how it looks?