Report Generation Using advanced data scrapping

Members only Use Cases Repository
, , ,
1

Report Generation Using advanced data scrapping

Use Case Description

data to be scrapped and added to excel as rows and columns, please help me

Rules

Scrap all data

Data is delimited with “|”

Add data to excel

Add only completed = true items to output

Tip

After scrapping text use, Text to Table activity

AS-IS WORKFLOW, TO-BE WORKFLOW

merge_from_ofoct.jpg
merge_from_ofoct.jpg856×2324 129 KB

Other information about the use case

Industry categories for this use case: Information Technology and Services

Skill level required: Beginners

UiPath Products that were used: UiPath Studio, UiPath Orchestrator

Other applications that were used: Excel, CSV

Other resources: You can Find resources from
Vajrang.org website Training → Challenges → Datascrapping

What is the top ROI driver for this use case?: Increase employee engagement

2

Once you have scrapped the data as per you the data is in the one column only and are separetd with “|”, so

  1. Use Generate Datatable activity to get the correct datatable and pass the separator as “|” in the Generate Datatable activity, this will give you the actual datatable
  2. Use the filter activity to filter the data as per the condition.
3

@Sanjit_Pal your idea is correct , let me know how much time did the bot take to complete this challenge

4

It depends on the amount of data to be scraped as generating table or filtering will take very less amount of time

5

Well the data loading is not static and completely dynamic check how you can handle it.