Comparing two Excel Sheets in UiPath (Tutorial from Start to Finish)
This video tutorial shows how to compare Excel sheets in UiPath. The tutorial starts with converting the Excel sheets into DataTables and then use a nested For Each loop to make the comparison. First, it's shown how to find matching rows, then unique rows, and finally how to merge two Excel sheets.
Download the course materials: https://andersjensen.org/how-to-compa...
VIDEOS FOR YOU:
🔹 Compare Excel Sheets in UiPath (Full Tutorial): • How to Compare Excel Sheets in UiPath...
🔹 UiPath For Each Loops: • How To Use For Each Loops in UiPath (...
👨👩👧👦 Discord: / discord
Join my network with 1800+ 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 using the UiPath activities is very easy. First, download the Excel sheet from the course materials above.
0:54 Find matching Excel rows
Read the two Excel sheets into DataTables using a Read Range activity. Best practice says you should use a variable for the Excel path in the Read Range. DataTables are very easy to work with - that's why we use them. We'll use a nested loop to compare the two Excel sheets. First, we update the first Excel sheet for all the rows that match the rows in the second sheet. Then, use an IF to compare the two Excel (DataTable) rows. Finally, use an Assign activity to update the Excel sheet whenever the UiPath loop finds a matching row. Finally, write the DataTable back to Excel using a Write Range. Let's edit the flow and write the matching rows to a new sheet. Again very easy. We create a DataTable to write to (with the headers from the sheets we compare). Use an Add Data Row activity, and to copy an entire DataTable row to a new DataTable, we fill in the ArrayRow with CurrentRow.ItemArray
20:43 Find unique Excel rows
We'll find Excel rows present in the first sheet but not in the second. Using the previously created nested loop and a created boolean variable, we can easily find the unique excel rows.
27:19 Combine two Excel sheets
We can very easily combine two Excel sheets. Use the Merge DataTable to merge the two DataTables. And use a Remove Duplicates activity to remove similar rows.
#rpa #uipath #excel
Смотрите видео Comparing two Excel Sheets in UiPath (Tutorial from Start to Finish) онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Anders Jensen 07 Март 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 9,576 раз и оно понравилось 168 людям.