i have all my three excel files in single folder and now i have to merge all together in a new excel file can anyone suggest me how to do it?
Is the Schema of all three Excel sheets are Same.?
If all of your files have the same columns, you can do the following:
- Get list of all files in your folder
- For Each loop on your result from 1
- Read range on workbook
- Use the Merge Datatable activity to append each Datatable to a master Datatable
You can also try to use this component. This has a template that supports your need
Is Merge Datatable a standard activity or do I need a special package? Do you know the name of that package?
Data is all sitting in column A, but has a slightly different number of rows.
what if they have different schema?