I have a excel file which contains some URLs. I used read range to go from excel to data table (DT1).
Example www.com www.com
Then I setup a bot that visits each URL and scrapes one piece of data (a number). It then stores this into a new data table (DT2).
Example:
25
89
My question is how do I put the data from DT2 into DT1. I don’t want to append it into the same column. Rather I want to add a new column (at the end), and I want the rows to match up with the URL
Example www.com 25 www.com 89
I hope this makes sense. If there is an easier way to do it other then the way I described I want to do it, please let me know.
Your provided links are not working for some reason. However this is what I understood from what you have described.
You have a excel with a list of URLs. You extract the excel to a datatable.
Then you loop through this datatable, Go to that website and scrape a number and stores it into another datatable. So, For each URL, you only have one number/ one row in the DT2 right?
Now you need to get that DT2 data into DT1 as a new column. So since for each URL, you have only one row in DT2, it can be done easily…
Check out the below workflow. It is bit similar to your requirement. I created this to help one of the friends here in the forum too… It will work for you as well.
Note: This will only work if you have one row in DT2 for each URL you have in DT1
Let me know if this is not your requirement. Since the links you provided is not working for me, I am writing to you from what I understood from the description of yours.
Question. Why is there a DT called FinalMatchList, what is the purpose of this?
And also why did you put a loop within a loop?
which DT is valuefield1 located in?
I’m fine with just duplicating your workflow but I would also like ot understand how it works
Please take a look at the flowchart.
URLTable is the one with the URLs and sessionTable is the one that gets one piece of data from web.
I need to add sessionTable as a new column into URLTable. Then put URLTable into an excel.
Let me know how I can do this, as I did not understand how your example works