Extract Data from Line Items

Help Studio
1

image
image1411×414 13.3 KB

I have a form which is having 25 line items like this above screenshot. Each line item has two part
Delivery Forecast Items- Unstructured table
Delivery Items-Structured table which spans over multiple page itself
I want to extract the Data from the form , But I don’t know How we can achieve this.
The above screenshot is Line item no 1 and i need to extract both table data for all line items

2

Hey @agathiyanv

Let’s first talk about Delivery Forecast items

Please highlight in the above image on which data you want to scrape please ?

Thanks
#nK

3

Hello @agathiyanv
You can use data scraping metod to To extract the deliver items and it can navigate next page by indicate the next page navigate button
image

4

I need to extract both table data for all 25 line items

5

I have 25 table like this and I need to automate the process. In such scenario how to do data scrapping.

6

@agathiyanv
1.Get the count of forms as FormCount in integer
2. assign Count=1
3. use while loop conditions, Count<=FormCount
3.1 within condition draft your flow,
3.2 set data table ectraction process
3.3 set assign Count=Count+1

7

It will work for only one line item but I have 25 line items

8

@agathiyanv Will you give me more input.
25 lines mean?
show me the screenshot and also output currently you obtained and what your expectation

9

The screenshot i posted there is one line item, like that I have 25 line items.

10

25 line Items in different pages or same page?

11

It’s same page