How to merge 2 excel sheets

Hi All,

I want to merge 2 excel sheets.
Sheet 1
Sheet 2

I used Join datatable activity iam getting out put like this.

sheets.xlsx (13.8 KB)
Can some one help me.

Hi @thima

Can u Share the the screenshot of what u have provided in join datatable activity ?

Have you tested to set Column Table 2 to “DIRECTORY_NUMBER” (without the 1)?