MarketplaceStudioActivityDataTable Activities

Create your first automation in just a few minutes.Try Studio Web

DataTable Activities

DataTable Activities

by Lakshman Ganta

8

Activity

Downloads

3.3k

back button
back button
next button
next button

Summary

Summary

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

Overview

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.

Features

Features

1. We can easily change the column position. 2. We can easily convert the given DataTable to Dictionary, JSON, XML and HTML String and also we can convert JSON string to DataTable. 3. We can easily replace a particular string in an entire DataTable. 4. We can easily convert Columns to Rows and vice versa. 5. We can easily replace column names and print all column names in given DataTable. 6. We can merge two DataTables Horizontally.

Additional Information

Additional Information

Dependencies

Newtonsoft.Json [12.0.3]

Code Language

Visual Basic

Runtime

Windows Legacy (.Net Framework 4.6.1)

Publisher

Lakshman Ganta

Visit publisher's page

License & Privacy

Apache

Privacy Terms

Technical

Version

1.0.0

Updated

April 24, 2020

Works with

Studio: 21.10 - 22.10

Certification

Silver Certified

Support

UiPath Community Support

Resources

Similar Listings