You are currently viewing How to merge columns from two different DataTables in UiPath

How to merge columns from two different DataTables in UiPath

On my YouTube Channel,, 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:!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:!Al9RjoWZcShJib5e-dWh2WZwpqPaTw?e=MKVaYu

Anders Jensen

RPA DEVELOPER, YOUTUBER & UIPATH MOST VALUED PROFESSIONAL 2021 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 colleagues 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.

Leave a Reply