How to Compare DataTable Column Headers in UiPath - Full Tutorial

Опубликовано: 30 Сентябрь 2024
на канале: Anders Jensen

6,240

This video tutorial shows, how to compare headers from two DataTables in UiPath and copy the entire columns, where the headers match.

You could also watch:
🔵 UiPath Excel and DataTables Complete Playlist -    • UiPath - Work with Excel and DataTabl...
🔵 Compare two Excel Sheets in UiPath -    • UiPath | Compare Two Excel Sheets (/D...

0:58 Excel Application Scope
We need the scope outside all our Excel activities in UiPath. The Read Range is used to read the Excel sheet into a DataTable, which enables us to work with the data. A DataTable only exisits in the memory, when our workflow runs.

2:50 Arrays with Column Headers
First we create two Array of Strings and then we can add the column header names to them with C# LINQ. We then use a For Each to just print out the column names.

7:28 Compare Two Arrays
We can now compare our two arrays with column header names. The gameplan is to have a nested For Each, where we compare the arrays.

Connect with me:
🔔 Subscribe - http://www.youtube.com/user/klogeande...
💼 LinkedIn -   / andersjensens
👥 Facebook -   / andersjensenorg
💌 Email Newsletter - https://andersjensen.org/email-newsle...

#uipath #rpa #automation