DataTable Activities

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

This package contains the below activities:

• Change Column Order - Changes the ordinal or position of the DataColumn to the specified ordinal or position.
• CheckMandatoryColumnsExist - Checks if all the mandatory columns exists in the DataTable.
• ConvertArrayIntoDataTable - Converts an array into the DataTable.
• DataTable Operations - Compares DataTables to be matched, unmatched, combines 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 - Prints all column names of a DataTable.
• Merge DataTable Horizontal - Merges two DataTables horizontally.
• Rename Column - Renames the column name with a new name.
• Replace string in DataTable - Replaces a particular string with a new string in the entire DataTable.
• Select certain Columns - Selects certain columns from a DataTable.
• Skip/Take Rows - Skips/Takes rows from a specified DataTable.
• Transpose DataTable - Converts DataTable Columns to Rows and Rows to Columns.

1. We can easily change the column position.
2. We can easily convert the given DataTable to Dictionary, JSON, XML and HTML String, and we can also 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 a given DataTable.
6. We can merge two DataTables horizontally.
7. We can easily convert Arrays into DataTable.