Add two table in One Excel

[Himanshu_Pratap_Rana (Robot Master)]

Hi I have two table extracttable1 and Extracttable2.How to add and write in one excle

[fernando_zuluaga]

hey

use the append range activity

regards!

[Nithinkrishna]

Hey @Himanshu_Pratap_Rana

Yes possible in two different sheets or in the same sheet as well.

Thanks
#nK

[Himanshu_Pratap_Rana (Robot Master)]

How to add in one excel.Please give me example.

[Nithinkrishna]

Hey @Himanshu_Pratap_Rana

1. Use Excel where you choose the XL file path

2. Use Write Range & pass the ExtractDt1 Data Table

3. Use Append Range & pass the ExtractDt2 Data Table

Hope this helps

Thanks
#nK

[Shakti_Singh]

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.

[Nithinkrishna]

Hey @Shakti_Singh

Yep, Merge Data Table should also work which will need just one write range activity at the end to write the table to Excel.

Thanks
#nK

[ushu (Usha kiranmai)]

@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

Output