Dive into more complex automation tasks, including identifying leap years, writing and reading values in text files, and manipulating arrays. Elevate your data handling skills with UiPath Studio Web. Learn to generate data tables from text files and perform advanced string operations such as concatenation of first, middle, and last names.
About this event
📣 Welcome to Day 2 of the UiPath Studio Web Workshop, we will delve into advanced techniques for array analysis and data categorization using UiPath Studio Web. Join us as we explore how to streamline your automation processes, enabling you to efficiently organize and categorize data. In this session, we will also elevate your data handling skills with UiPath Studio Web. Learn to generate data tables from text files and perform advanced string operations such as concatenation of first, middle, and last names. from text files and performing advanced string operations. Join us as we delve into practical exercises to enhance your proficiency in data.
👉 Topics covered:
📌 Task 1: Array Extremes
Find Max and Min Values from List of Array of Numbers
📌 Task 2: Data Segregation by Switch activity
Utilize "Switch" Activity for Data Categorization
Organize Data into Distinct Excel Sheets by Departments
📌Task 3: Generating Data Tables
Overview of Generating Data Tables from Text Files
Practical Exercise: Generate Data Table from a Sample Text File
📌 Task 4: Concatenating Names in Excel
Extracting First Name, Middle Name, and Last Name from Excel
Concatenating Names and Writing Results into Full Name Column