How to Compare and Copy DataTable Columns in UiPath

Learn how to compare column names (headers) in Excel/DataTables and copy entire columns of data to a new table, when there is a match.

The video was made per request from a viewer, who wrote:

Hello Anders,
 
I saw one of your YouTube videos and am really impressed with the explanantion you give. I am new to Uipath and kind of in a pickle right now. I am trying to compare headers of 1 Excel file with headers of a 2 Excel file( This will be the standard header template file). And right the result to a 3rd Excel file ( Results). But whatever I do is failing. Even the forum has no answers. I know rows can be matched but how do I match the headers since they are columns? 
 
If you could please help me that would be greatly appreciated.
 
Kind Regards

I like to solve UiPath RPA problems. If you have a specific one, please do comment one of my YouTube videos and I gladly give it a go 🤓 However do remember that I do not have time to solve entire workflows.

Download the workflow and excel files from the video here

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

2 comments

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

  • Hello Anders,
    Thank you for the videos you make and heartily congratulations on the 1K subscribers on YouTube. Yes I’m still looking for the API which you told me for the Covid-19 real time data extraction .
    I am a beginner & just started to make my transition towards RPA and I’m learning by watching your videos.

    Please do also suggest, which topics to focus on in UiPath RPA and keep making wonderful videos.

    Thank you

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.