I got the following issue.
I have a Orderlist from CustomerA (named CustomerA.xlsx) where I have to extract the data from and load it into the “Master” Excel Orderlist.xlsx. The “Master” Excel called Orderlist.xlsx has different Column Names and is always without any data in the beginning - just the column names. I’m struggling finding a solution so that the data from CustomerA.xlsx according to its column names are loaded into the Orderlist.xlsx.
There are different Customers with different Excel Column Names (see CustomerB.xlsx). I’m not getting into a solution to work with dynamic column names.
First, I tried to two different DataTables:
- dt_master which has the column names of Orderlist.xlsx
- dt_customer1 which was read into DataTables with Excel Application Scope
Then I wanted to join the DataTables but totally forgot the logical function of Joining. So I searched the forum for some similar issues but none of these helped me out since their basic problem were different.
Hope you understand my problem, will try to explain it better. Tried to find a solution the whole night with all the datatable activities as well as excel activities.
Thanks for any help!