How to merge columns from two different DataTables in UiPath

On my YouTube Channel, https://www.youtube.com/channel/klogeanders, I got a great question from Damaneed, a subscriber, in where he wants to merge columns from two different DataTables.

Fig. 1: Case from Damandeep, a subscriber to the channel

I solved it in the video here and if you want the workflow files check below:

Download the workflow files: https://1drv.ms/u/s!Al9RjoWZcShJib0DhslDDeh42_BNAg?e=YPcugI

I’ve updated the workflow afterwards, since Damandeep wanted a solution, where we only update columns to Sheet1 from Sheet2, if that column name is not in Sheet1. You can find the updated workflow files here: https://1drv.ms/u/s!Al9RjoWZcShJib5e-dWh2WZwpqPaTw?e=MKVaYu

Anders Jensen

RPA DEVELOPER & YOUTUBER

Anders Jensen is the RPA Lead at Lessor A/S (Part of Paychex Inc) and an advanced certified UiPath RPA Instructor.

Using his extensive experience in automating interfaces such as Windows, SAP and browsers Anders develops enterprise RPA solutions automating work for customers and collegues one task at a time.

In the evenings and weekends Anders is passionate about teaching others RPA by making instructional videos on his YouTube channel.

View all posts

Add comment

Your email address will not be published. Required fields are marked *

Anders Jensen

RPA DEVELOPER & YOUTUBER

Anders Jensen is the RPA Lead at Lessor A/S (Part of Paychex Inc) and an advanced certified UiPath RPA Instructor.

Using his extensive experience in automating interfaces such as Windows, SAP and browsers Anders develops enterprise RPA solutions automating work for customers and collegues one task at a time.

In the evenings and weekends Anders is passionate about teaching others RPA by making instructional videos on his YouTube channel.