DataTable Activities

Bronze Certified

Custom Activity

8 reviews

1.1k

DataTable Activities

Bronze Certified

Custom Activity

8 reviews

1.1k


Summary

This package contains automations of advanced and frequently used DataTable features.

Overview

This package contains the below activities:
  • Change Column Order - Changes the ordinal or position of the DataColumn to the specified ordinal or position.
  • DataTable Operations - It compares DataTables to get matched, unmatched, combine list of all rows in both tables.
  • DataTable to Dictionary - Converts DataTable to Dictionary.
  • DataTable to HTML - Writes a DataTable to HTML String.
  • DataTable to JSON- Writes a DataTable to JSON String.
  • JSON String to DataTable - Writes a JSON String to DataTable.
  • DataTable to XML- Writes a DataTable to XML String.
  • Display DataTable Columns - It will print all column names of DataTable.
  • Merge DataTable Horizontal - It will merge two DataTables Horizontally.
  • Rename Column - It renames the column name with new name.
  • Replace string in DataTable - It will help you to replace a particular string with a new string in the entire DataTable.
  • Select certain Columns - It helps to select certain columns from DataTable.
  • Skip/Take Rows - Skip/Take rows from a specified DataTable.
  • Transpose DataTable - It converts DataTable Columns to Rows and Rows to Columns.
  • DataTable Aggregate Functions - It helps to apply aggregate functions like Average, Count, Min, Max and Sum on a specified column in a given DataTable.

Benefits


Published: 2020-04-24T14:19:19+00:00 | Updated: 2020-12-18T13:30:19+00:00

Lakshman Ganta
RPA Developer

Bangalore, Karnataka, India


License

Apache 2.0


Code Language

Visual Basic


Tags

Aggregate Functions
datatable
DataTable Activities
DataTable Features
html
json
xml
[hackathon]

Compatibility

Compatible with previous and current versions of UiPath Studio.


Dependencies

Newtonsoft.Json [12.0.3]



Similar Listings