Data tables combine

Develop
1

Hi,

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.

image
image747×271 5.56 KB

image
image712×323 5.83 KB

image

2

Hi @Aishwarya ,

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

1 Like
4

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