Connect HomeMarketplaceComponentsNovigo Solutions-Auto Rename Duplicate Column Name

Novigo Solutions-Auto Rename Duplicate Column Name

Snippet

Snippet

Updated: October 22nd, 2020

Published: July 14th, 2020

Downloads: 15

Language compatibility: Visual Basic

Community Support

Novigo Solutions-Auto Rename Duplicate Column Name

Snippet

Summary: 

This workflow detects the duplicate column names and renames it by adding the number of occurrences as suffix.

This Snippet has three arguments:

Input Arguments:
1. in_FilePath (String): Path of the Excel file for reading and renaming the duplicate column names. Required.
2. in_SheetName (String): Name of the sheet in Excel file for reading and renaming the duplicate column names. Required.

Output Arguments:
1. out_DataTable (DataTable): This is the output argument which returns a DataTable after renaming the duplicate column names. Required.

Details

Benefits

This workflow renames all repeated column names and also makes sure that the renamed column names are not repeated.

Compatibility

Compatible with all Studio versions starting with 2018.4.1.

Dependencies

UiPath.Excel.Activities
UiPath.System.Activities

Resources

- User_Guide.pdf

Licensing

By clicking download you agree to the following license.