Three tables to one

Help Studio
1

Hi,
I have three tables with the same column names and I have to save each to one datatable and paste it to another sheet combined.

2

Have a Look on the merge datatable activity

1 Like
3

I use for each loop to read all three tables and save them in datatable and then copy to template table. merge does not work for me.

image

4

you can use append datatable to a new datatable inside the for each loop

5

Could you please explain how

6

theirs a activity call append Range it will append your data to a sheet if it already exist or create a new sheet
you can read range inside for each loop
and also append Range inside it

Thank you

7

It’s not combining those three tables

image
image594×726 18.1 KB

8

check this it would help you

9

Hi @markosc

Can you please share a dummy excel file so I can create a workflow for you. ?

Thank you,
Prashant

10

a more detailed description on what is not workling would help for further guidance. What was doen, what did you get, what is missing. Thanks

1 Like