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