Data tables combine


I have 2 excel sheets, one with 4 rows and other with 6 rows, I want to get all the rows from sheet1 and the not matching extra rows from sheet2 and paste the combination of both in sheet3.

PFB sheet1 and sheet2 and the expected ouput in the 3rd image…
please assist in how to achieve this scenario… thank you so much in advance.


Hi @Aishwarya ,

You can try to use Join DataTable activity to do this.

1 Like

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