Merge two datatables and place it in one sheet

Help Studio
1

I have two datatables i want to place it in one sheet.
But i want second datatable above and first datatable below.

Please help

2

Hi @Tabbu

Write range the second datatable!

And Use append range to append the first datatable after second Datatable!

Regards

2 Likes
3

@Tabbu Hi, Please follow as @pravin_calvin said. Img for reference.
image

1 Like
4

Hi @Tabbu ,

Merge data table activity have two input arguments one is source data table and destination datatable. the mechanism of the merge is destination will come first and source come second. So use the data table you want first in the destination and second should be in source.

the main point is for merging data table you should have same column names. thanks

3 Likes
5

But this activity is only valid inside excel application scope.Nd i m getting datables from datascrapping.So there is no use of excel application in my case.

Thanks for ur effort!!
But please provide a solution of mine case

6

Hi @Tabbu

Could you explain your scenario bit more elaborate?

Regards

7

Yess!!
I have extracted a data using data scrapping
Like these i have scrapped two times.Nd store the result in datatables.So i got two datatables.
Now i want to merge the datatables in 1 sheet .
But i want to places 1st datatable then leaving 1 row ,then need to place 2nd datatable just below the 1st datatable.

I m stuck in my project please help

8

Hi @Tabbu
use this syntax
first write the first datatable into excel starting index as A1
then use assign activity to get length of the first datatable
length=Datatable1.rows.count
use another write range to write Datatable 2 (starting index as ** “A”+length+2.ToString**)
Thanks,
Robin

1 Like
9

@Tabbu Hi, While you scrap the data from the web page, (ex)

  1. scrap the first table and store the variable as your wish “extracted_result1”

  2. scrap the second table and store the variable as your wish “extracted_result2” and Write it on excel1.

  3. append range call excel1 and apply extracted result1.
    Main.xaml (11.9 KB)

Cheers.

10

Using this evrything is fine but the problem is in second datatable which i m gonna place it down having headers. So when i m using this append range and adding add headers in the properties of write range activity then the headrrs of second datatable is getting at the starting and rest of the datatable are getting after the first datatable.

Please help in it

11

untick the add headers property of second datatable

12

Getting error in indexing at datatable2

13

Datatable is extracted through data scrapping so there is no properties in that of add headers

14

before gonna write the second datatable

create a int variable (Ex count)

Count=Datatable.Rows.Count

in the second write range activity starting range as “A”+(Count+2).ToString

15

no you have view add headers property on write range activity

16

Thank you so much .This is working

17

no issues

18

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