How to merge 2 excel sheets

Help Studio
1

Hi All,

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

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

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

2

Hi @thima

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

3

image
image791Ă—375 7.76 KB

4

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

1 Like
5

HI @thima,

Please take a look at this. it has the options"Cell range" and start column that appends the selected range…

Regards
Balamurugan.S