Data was overwritten

[tombillydavid3]

Hi supporters,

I would like to store my data from web scraping into Excel and I need search data for each row. For example, I wanna search following Phone types(iPhone 11, iPhone 12, iPhone 13 and so on) on google, and then extraction price, color and other information for each iPhone into Excel.
But I got failed as the data was all overwritten and only the last record was left.

The other question is how can I extract and store those information in designated excel sheet and then specific cell.

Thank you!

[lrtetala (Lakshman Reddy)]

Hi @tombillydavid3

Can you show the Workflow screenshot and if you are using Extract Table Data activity check Append Results option

Regards,

[tombillydavid3]

Hi Irtetala,

I did use the Extract Table Data and did click on the append, but still got failed.
My workflow provived for your reference. Appreciate your great support!

[tombillydavid3]

[tombillydavid3]

[lrtetala (Lakshman Reddy)]

@tombillydavid3

After Extract Table Data activity use Append Range Workbook activity

Output of Extract Table Data activity give to Append Range Workbook activity

Regards,

[Anil_G (Anil Gorthi)]

@tombillydavid3

In extract datatable…use a dattable variable

Then use merge datatable after that and create one more output table

After the loop is completed use write range and write the final output table

Cheers

[tombillydavid3]

Hi Anil,

You mean like this? or is there steps I missed?
Please kindly give me further setups. Thank you!!!

[Anil_G (Anil Gorthi)]

@tombillydavid3

after that extract

use a merge datatable and pass extract as input and merged datatable as a new table again

move write range outside the loop

cheers