Skip to main content

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
Labels:

Comments

Post a Comment

Popular posts from this blog

Shell script to find factorial of a number

You can create a shell script to find the factorial of a number using a while loop. Here is an example: In this script, we prompt the user to enter a number and store it in the variable number . We then initialize two variables, factorial and counter , to 1 and the value of number , respectively. We use a while loop to iterate through the numbers from the value of number down to 1. In each iteration, we multiply the current value of factorial by the current value of counter , then decrement the value of counter by 1. At the end of the loop, we output the final value of factorial , which is the factorial of the number entered by the user. You can execute this script by making it executable by running chmod +x scriptname and then you can run ./scriptname. Make sure that you have bash installed in your system, otherwise, you have to use a different shell accordingly. This script uses a for loop to iterate from 1 to the given number, and calculates the factorial by multiplying the cur...
Post a Comment
Read more

Difference between static ip and dynamic ip

An IP (Internet Protocol) address is a unique numerical label assigned to every device connected to a computer network that uses the Internet Protocol for communication. There are two main types of IP addresses: static and dynamic. A static IP address is a fixed IP address that is manually assigned to a device. Once a static IP address is assigned to a device, it does not change, regardless of whether the device is turned off or disconnected from the network. A dynamic IP address, on the other hand, is assigned to a device dynamically, typically by a DHCP (Dynamic Host Configuration Protocol) server. Dynamic IP addresses are assigned each time a device connects to a network, and they can change over time. Here are some differences between Static IP and dynamic IP Persistence: Static IP addresses are persistent and do not change, whereas dynamic IP addresses are assigned each time a device connects to a network and can change over time. Manual or Automatic Configuration: Static IP addre...
Post a Comment
Read more

What is UiPath Orchestrator

UiPath Orchestrator is a web-based application that enables the management and monitoring of UiPath Robots and processes. It is a central hub for managing and controlling all your automation tasks, making it an essential tool for enterprise automation. With UiPath Orchestrator, users can easily manage their automation tasks by creating, scheduling, and monitoring processes. The platform allows you to deploy, schedule, and monitor your automation workflows, as well as manage the robots that execute them. The application also provides you with detailed analytics, allowing you to optimize your automation and make data-driven decisions. Designed By: by MANOJ JHA One of the key features of UiPath Orchestrator is the ability to schedule automation processes. With its built-in scheduler, you can set up recurring automation tasks to run at specific times, ensuring that critical processes are executed even when you're not there. Additionally, you can also trigger automation workflo...
Post a Comment
Read more