I want to merge the 2 unstructure excel files?

[Naveen_Kanike]

i wanted to merge or combine the unstrutured excel files in first file and second file iam having simillary column name and i need to add that similary column names and along with required cloumns also how to do this

please find the 2 files inputs sheet are files and in output sheet i want results of match fileds along with required fileds
inputsheet.xlsx (7.3 KB)
inputsheet1.xlsx (7.5 KB)
outputsheet.xlsx (6.0 KB)

check my workflow please

TestVersion of MIR7 Validation.zip (37.0 KB)

[Naveen_Kanike]

can any one help me please

[Kanak_Lata_Singh]

Hi @Naveen_Kanike

Naveen , you can try converting / reading the data as Datatable , then merge datatable together , add custom column names and then write them in an output excel sheet .

For reference please refer

How can we extract data from Unstructured excel

How can we extract data from Unstructured excel.

Merging of datatables

Hi, I have 5 excel files in a folder and want to merge data tables. I used “For each file in the folder” activity to pass the files and I used “Excel application scope” to read the “sheets” by using “Get Workbook Sheets” and a “Read Range” activity. Now How can I merge the data tables from the files in the folder. How can I use 2nd “Read Range” activity to read other file to merge as “merge datatable” requires atleast 2 data tables. Regards,