Report Generation Using advanced data scrapping

Report Generation Using advanced data scrapping

Use Case Description

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


Scrap all data

Data is delimited with “|”

Add data to excel

Add only completed = true items to output


After scrapping text use, Text to Table activity


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 website Training → Challenges → Datascrapping

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

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.

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

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

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