Is it possible to append the datatable

Help
1

I want to datascrape some data from web and place it in a datatable.
Every time i need to place the data from ExtractDataTable to ADT(Datatable)

2 Likes
2

Yes you can append the data using append range activity

3

Thankyou for your response @Naveen

Append range is for Excel

4

Hi @RachelN,

I got what you want.
to append DataTable you can use Merge Data Table activity.
You’ve to just specify Source & Destination (DataTable variavles)

5

Hi @RachelN,

You can use ‘Join Data Tables’ activity, and use ‘Inner Join’ or ‘Left Join’ or ‘Full Join’ whether required.

Thanks & Regards,
Apurba

6

Fine
Append range can be used only when we are using excel directly not getting into usage of datatable
and moreover the extract datatable activity will give us straight away a datatable

hope these steps would help you resolve this
–lets take like you have the datatable ADT ready
–once after getting the output from Extract datatable activity with a datatable named outdt, now use MERGE DATATABLE activity where in the Source mention as outdt and Destination as ADT in the property panel of MERGE DATATABLE activity
–so each time when the datatable is extracted it will get merged to the destination datatable which is here mentioned as ADT

for more example here you

hope this would help you
Cheers @RachelN

7

Thankyou @Palaniyappan it worked

1 Like
8

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