How to Scraping from web page, and organize the result

Hi,
I have to collect several web pages, and bring the data to excel, excluding many details, and organize the arrangement.
The web page looks like this:

I need result like this:
image
[the value of the first column is already available previously]

If I extract data from UI Path, the page on excel, I get this result.
datatable.xlsx (8,9 KB)

How can I arrange the data,
whereas the number of PO Lines is variable, from project to project?

ex:
image

thaks a lot…

Hi @AaronMark,

did you tried to use data scraping and manually define data structure…

Check this

Thank You,
Shubham Pratap

Hi Shubh,
I don’t understand the instructions, and it seems to me that they haven’t found a solution.
I am not very experienced, I am acquiring most of the skills, making living experience.

Perhaps, starting from my excel file, processing the data is easier.
That is, I could perform full scraping, and with rules, which I don’t know, take the data.
Let me explain:

datatable.xlsx (9,0 KB)

In the attached file, in blue I have indicated the column headings.
(grouped, they are 4 specific values).

For each cell that contains this value:
“PO Line #”
“Submitted Amt”
“Due Date”
“Actual Completion”

I have to collect the value contained in the cell below.

The number of cell “PO Line #” is variable in a file.
It could be a single PO Line, two, or three, as in the example.

Maybe so it’s easier to imagine the flow,
but I don’t know how to set the default cells, and how to tell uipath to get the data, in the cell below.

Any suggestions?

Hi @AaronMark,

Can i have access to web page from which you are extraction data.

Thank You
Shubham Pratap

Hi Shubh, sorry, but
It is in corporate VPN lan.
I have no way of sharing it unfortunately.
Can I provide part of my Workflow?
Or the file I uploaded above.

1 Like

Hi @AaronMark,

Can you check this, it explains correlated data extraction.

Thank You,
Shubham Pratap