Advanced Data Manipulation with Studio

About the Advance Data Manipulation with Studio course

In this course, we'll cover some more advanced data manipulation techniques in UiPath Studio. More specifically, we'll perform a wide range of data manipulation operations using the DateTime variables. What’s more, we’ll use LINQ to filter DataTables and Lists.

Product Alignment: This course was built using the 2022.10 product version of UiPath Studio and is applicable to newer versions as well.

Prerequisites for Advance Data Manipulation with Studio course

• Automation Developer Associate Training: This learning plan will teach you how to use data in Studio and create better user interface automation projects. You'll also learn how to make things like Excel, PDF, and email work automatically. Specifically, you'll learn about these topics: 
• Variables, Constants and Arguments in Studio. 
• Control Flow in Studio. 
• Excel Automation with Modern Experience in Studio. 
• Data Manipulation with Strings in Studio. 
• Data Manipulation with Lists and Dictionaries in Studio. 
• Basic Programming Knowledge. 
• Import the System.LINQ Namespace in UiPath Studio. 

Course Audience

This is a one hour and twenty-minute course aimed primarily at Automation Developers.   

Advance Data Manipulation with Studio Course Agenda

• Introduction to LINQ. 
• Filtering Data in Collection. 
• LINQ for Lists. 
• LINQ for DataTables. 
• Exercise: Analyzing Sales Data using LINQ 
• Working with DateTime Variable. 
• Exercise: Calculate a Date Time Difference.

Advance Data Manipulation with Studio Course Objectives

At the end of this course, you should be able to: 

• Analyze and evaluate the core concepts, principles, and practical benefits of LINQ queries for data manipulation and retrieval tasks.  
• Interpret LINQ lambda expressions and their programming significance, along with demonstrating effective application of LINQ techniques. 
• Identify the potential benefits of using LINQ for data manipulation. 
• Implement LINQ techniques to manipulate and extract data as needed.  
• Apply principles of LINQ to manipulate a given list of numbers through a series of operations. 
• Apply LINQ techniques to effectively filter and analyze employee data within a DataTable. 
• Implement the LINQ operations on sales data using UiPath Studio. 
• Use specific methods to perform data manipulation operations using DateTime variables. 
• Develop a workflow to calculate the DateTime difference between two events.