Hello Everyone,
I am trying to create a workspace where I extract search results, from web, to excel. While I have successfully used Data Scrapping tool to extract info, I want to make a little adjustment to the workflow.
I want to have all the data from the specified search results in 1 cell, instead of the bot writing it in different rows.
For example: the bot searches ‘iPhone’ → the extracted data ('iPhone 13, iPhone 12,…) in one cell beside ‘iPhone’ in excel.
Note: Some search results have 1 output and some have more than 1 result.
Thank you in advance for the help
PS: Reposting since the last post did not provide solutions 
Hi @hashibulh ,
You can loop through the generated excel and manipulate the data as per your requirement. For Example use for each first to loop through the items , the we can add the row items into a single variable using string .join and the write to to a new sheet
Hello @hashibulh ,
It would be better if you can share the screenshot of the current data and the required format.
Hi!
After scraping the data and successfully dumped in to excel. Try like this.
1.Read the excel file output as ExcelDt
1.Take one build dt and create only one column. output as BuildDt.
2.Take one for each row in data table -ExcelDt
3.Take one add data row activity Dt As BuildDt
in the array of rows mention like this
{CurrentRow(0).tostring+CurrentRow(1).ToString+CurrentRow(3).ToString}
Take one write range mention the dt as BuildDt
Regards,
Basically want all of the extracted data to be beside their respective names. Some of the search results have more than 1 output. For that case, I want all of the output to be beside the respective name but in one cell.
Yoichi
Raja.G
mkt.scott4