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
Смотрите видео How to Compare DataTable Column Headers in UiPath - Full Tutorial онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Anders Jensen 23 Май 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 6,240 раз и оно понравилось 71 людям.