Append data to a data table without using append range(Excel)

Learning Hub Academy Feedback
, ,
1

hi,
Inside a for loop i use data scraping for each link(opening in browser) and append the extracted data in excel using Append Range.
But now i want to eliminate excel dependency. i want to store the appended data in a data table. how can i do this?

1 Like
2

@arjitcy

Hey, You can use merge datatable.

Make source as ExtractedDatatable and Destination as new datatble using new datatable

1 Like
3

HI @arijit1213

For this you can use Merge Datatable Activity
Check below link

Hope this helps

Thanks

4

@Srini84 @Lakshay_Verma
Hi,
I did this. But as a result i get blank as an output.

5

Make sure you are not initalising dt everytime and if your headers are same or not make sure you add headers.

6

Go through this post. You may have find your answer

https://forum.uipath.com/t/how-can-we-use-merge-data-table-activity/107556/3

7

Hi @arijit1213,

1.Start by creating a master Datatable say dtmaster at the beginning of the workflow , the schema should match your data what we are extracting from the web. The scope of the variable will be global to the sequence.

  1. Take a second datatable variable say dttemp that will store the data for each extraction.

  2. Inside the for each loop-

A. First assign the dttemp value = Nothing. - This will clear the existing data for every iteration.

B. Now invoke the workflow for extraction of data - This will help to manage the code - this workflow will output a datatable that you will put in variable dtTemp

C. Now use Merge Datatable activity and merge dtTemp into dtMaster.

  1. After the for each loop , use a write range and write dtMaster to Excel.

–
Mukesh

2 Likes
8

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