Hi I have two table extracttable1 and Extracttable2.How to add and write in one excle
use the append range activity
Yes possible in two different sheets or in the same sheet as well.
How to add in one excel.Please give me example.
Use Excelwhere you choose the XL file path
Write Range& pass the
Append Range& pass the
Hope this helps
Merge Data Table
Is used to append a specified DataTable to the current DataTable. The operation is more simple than the Join Data Type activity, as it has 4 predefined actions to perform over the missing schema.
Yep, Merge Data Table should also work which will need just one write range activity at the end to write the table to Excel.
@Himanshu_Pratap_Rana If below is the output that you are expecting then please check below workflow
Example.zip (10.8 KB)
First data table
Second Data Table
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.