How to Compare DataTable Column Headers in UiPath - Full Tutorial
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
Watch video How to Compare DataTable Column Headers in UiPath - Full Tutorial online without registration, duration hours minute second in high quality. This video was added by user Anders Jensen 23 May 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,240 once and liked it 71 people.