I need to map the data from one excel to another excel based on condition that their column names are same. Append is not matching the col names simply adding to first come columns. Pls suggest a solution. Thanks
If both files have same no. of columns and same type of data then use Merge DataTable activity.
Table 1 have 20 columns
Table 2 have 70 columns.
I only need to append values into those 20 columns
Try with Join DataTable activity once.