How to Compare Excel Sheets in UiPath (Full Tutorial)
This video tutorial shows how to compare Excel Sheets in UiPath. First, use the UiPath activities (low-code) and then C# LINQ (query component and code). The same method is used when comparing Data Tables. This is a full 1-hour tutorial teaching you everything about comparing Excel Sheets in UiPath.
📂 Download the course materials: https://andersjensen.org/how-to-compa...
VIDEOS FOR YOU:
🔹 UiPath REFramework Full Tutorial: • UiPath REFramework - Full Tutorial - ...
🔹 UiPath Beginners Course: • UiPath Beginners Course [2021] - How ...
👨👩👧👦 Discord: / discord
Join my network with +1600 RPA Developers, where we solve RPA problems, network, and help each other upgrade our careers. It's free!
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
🐦 Twitter: / andersjensenorg
💌 Email Newsletter: https://andersjensen.org/email-newsle...
MY GEAR (Amazon affiliate):
🖥️ My monitor
Samsung 49-inch CRG9 Curved Monitor = https://geni.us/MDpejc
If you are buying this, I can recommend the Mi Monitor Light Bar = https://geni.us/3Wwad
💡 Lights
IVISII 19 inch Ring Light and Stand = https://geni.us/fVCH3IC
Godox TL60 RGB Tube Light = https://geni.us/u0hxf
⌨️ Keyboard
Logitech Backlit Keyboard = https://geni.us/aT0ltB
📹 Camera
Sony FDRAX53-B = https://geni.us/gnAE
Lenovo 500 Full HD Webcam = https://geni.us/cZS4
🎤 Microphone
Rode Procaster = https://geni.us/XWvZN
Rode PSA1 Boom Arm = https://geni.us/LtDH275
Rode Shock Mount = https://geni.us/aAgP
Triton FetHead in-Line Preamp (improve your mic) = https://geni.us/cMAO
XLR Cable = https://geni.us/DfRbS
Focusrite Scarlett (you need this to connect the mic+headphones) = https://geni.us/BAoA6Na
Portable mic when I travel:
Rode Wireless GO II = https://geni.us/iqy0g6H
0:00 Intro
Comparing Excel sheets in UiPath is very easy. First, we use the UiPath activities and then LINQ. First, we convert the Excell sheets to DataTables, making them easy to work with. Remember to download the course materials: https://andersjensen.org/how-to-compa....
5:17 Find matching Excel rows and update a column
We use the UiPath activities to find matching rows between two Excel sheets. First, convert the Excel sheets into Data Tables, which will make them easy to work with. Use the Add Data Column to add a new column, where we will add data if the rows match. Using a nested For Each Row in Data Table and an If, we check if we have matching (intersecting) rows.
16:13 Copy matching Excel rows to a new sheet
Still using a nested loop, we use an Add Data Row activity to add the matching Excel rows to a new sheet.
21:52 Find unique Excel rows and update a column
We find the Excel rows present in Sheet1 and not in Sheet2, that is, unique values (= Except).
27:58 Copying unique Excel rows to a new sheet
We find unique Excel rows in the nested loop and still with the If condition and copy them to a new sheet. Using an And condition to compare based on multiple column headers.
34:03 Combine two Excel sheets (Union)
Use the Merge Table to union two Excel sheets and then Remove Duplicate to remove the same rows.
37:30 Compare Excel rows using LINQ
We use LINQ in UiPath (if you can't run it, make sure you have an imported system.linq). Use the AsEnumerable method to compare two Data Tables using LINQ and then Intersect, Except, and Union methods to find the matching, unique, and joined Excel rows using UiPath.
44:27 Compare Excel rows based on columns (Advanced LINQ)
We now use LINQ to compare specific columns in the Excel sheet and then update write the results to a new sheet using UiPath.
50:17 Try Catch (Error handling our LINQ query)
Our workflow will throw an error if we try to use the .CopyToDataTable, and there are now rows in the Data Table. We use the Try Catch activity in UiPath to solve this.
#uipath #rpa #excel
Смотрите видео How to Compare Excel Sheets in UiPath (Full Tutorial) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Anders Jensen 04 Февраль 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 11,922 раз и оно понравилось 220 людям.