Combine two tables

Hi, I have two excel files that are reports and they have the same file name for example (report200_56897.csv and report200_45689.csv) only numbers are different. I use for each to go through files in folder and use IF fileName.Contains(“report200”) and edit them with invoke code. Then I have to combine these two edited tables and paste it to the template table. How can I do that?

give a try on merge datatable activity

in case of the result differs from your expected out so just share some sample data along with the description of expected output with us. Thanks


go with @ppr’s way or you can also use append range activity to put all data in one file.

dt_copy = dt.Copy

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.