UiPath Data Manipulation and Variables Flashcards

Which UiPath activity converts a DataTable to a CSV-formatted string?

Answer: Output Data Table

The 'Output Data Table' activity serializes a DataTable into a pipe or tab-delimited string representation.

What does the 'Assign' activity do in UiPath?

Answer: Sets the value of a variable or property using an expression

The Assign activity is used to set or update a variable's value with any valid VB.NET or C# expression.

In UiPath, what is the purpose of the 'For Each' activity when used with a DataTable?

Answer: Iterates over each row in the DataTable

When the TypeArgument is set to DataRow, 'For Each' iterates over every row in the DataTable, exposing each row as the loop variable.

How do you access the value in the column named 'Email' from a DataRow variable called 'row' in UiPath?

Answer: row('Email').ToString

In VB.NET, DataRow column values are accessed using parentheses with the column name as a string key, then converted with .ToString.

Which UiPath activity should you use to sort a DataTable by a specific column?

Answer: LINQ OrderBy expression with Assign

UiPath lacks a native Sort Data Table activity, so sorting is done via LINQ: dt.AsEnumerable().OrderBy(Function(r) r('ColumnName')).CopyToDataTable().

What VB.NET expression checks if a List(Of String) variable named 'myList' contains the value 'UiPath'?

Answer: myList.Contains('UiPath')

The .Contains() method on any .NET List checks for the presence of a specific item and returns a Boolean.