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 […]

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

Please accept marketing-cookies to watch this content.