UiPath PivotDataTable Activities for Pivot table creation

UiPath has a vast number of external custom-designed activities that developers can use for their RPA projects. In this blog, I am going to talk about an activity that developers can use to create the pivot data table in Excel. 

Let's first understand what is a pivot table is and why anyone needs to use this. A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.    -Source

NOTE: In this package, it has some limitations where you will only be able to summarize data in a flat data table(Columns and rows). Providing a more clean visualization of the data.

You can download this package from the Uipath marketplace where it is available to use for free. This package is developed and published on the Uipath marketplace by Internal Labs. 

Pivot Data table package download link: Click here to download

Now I am going to show you how you can actually use this in your project. For this, I am using UiPath studio version 2019.4.4. You can check if this package supports your UiPath studio. After downloading this package open your UiPath Studio and create a new project. Now move the downloaded package to your UiPath local package directory for me it is C:\Program Files (x86)\UiPath\Studio\.\Packages. After moving this .nupkg file in the directory go to the UiPath package manager and search for this directory in your local then install it.

After installing the package create a data table type variable that holds the data from the excel table. For this example, you can download this sample data. Now add workbook read-range activity to read this excel data. In this activity keep the AddHeader option true and create a variable dt of datatable datatype. Now add Pivote datatable activity in this you'll see following properties:

• Column X - The X-axis column is the column with Unique Values to build the column header
• Column Y - The Y-axis value is the column with the values to be displayed as the rows in the first column
• Column Z - The Z-axis is the value and is the match of X and Y in the Data Source
• Datatable - This is the input datatable that we created when we read the excel data
• Output.PivotTable -  This is the Ouput Datatable