How to Compare DataTable Column Headers in UiPath - Full Tutorial

Published: 23 May 2020
on channel: 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

Watch video How to Compare DataTable Column Headers in UiPath - Full Tutorial online, duration hours minute second in high quality that is uploaded to the channel Anders Jensen 23 May 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 6,240 times and liked it 71 visitors.