Answered

Need Help Web Scraping Values from a Single Page

Like (0) Share

Report

Posted on 12 Sep 2023 12:13:32 by kelliadam

I am trying to Web scrape data from over a hundred pages, Each page contains data for one full record. However, PA treats each data piece as a row, and I need it to be a column (value). I'm saving to Excel. Please help.

Screenshot 2023-09-12 070025.png Screenshot 2023-09-12 065924.png

All responses (2)

Answers (1)

kelliadam 5 on 13 Sep 2023 at 00:01:49

Like (0)

Report

Re: Need Help Web Scraping Values from a Single Page

Thank you! It worked perfectly.
Verified answer

Agnius Bartninkas 10,045 Most Valuable Professional on 12 Sep 2023 at 12:19:44

Like (1)

Report

Re: Need Help Web Scraping Values from a Single Page

Click on the "Advanced settings" button in the extraction preview. Then make it extract "Handpicked values" instead of a table.

When you do that, you can specify a CSS selector for each value you want and the result will be a data row of handpicked values. When you have multiple pages, you'll get multiple rows.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.