I need help on scraping data on the above table.The table has 17 columns and i want to extract only two columns from the following tables Which are Document and Printing Time. From the Document i only want the document name that starts with HC-AG00 and on the Printing Column i only want the date and time of when the document was printed. I want to this process to be Automated after 24 Hours and be exported as a CSV File. I hope this is clear you to comprehend and help me in achieving this task. Thank you.
Welcome back to uipath community
Did we try with DATA SCRAPPING method in this
1.Use Data Scraping and scrape the Two Columns Document and Printing,then export into a Excel File.
2.Then Filter the Excel with the conditions you want.and export into CSV
Yes Buddy, when i scrap it scrapes all the 17 columns and yet only need to scrap Document Column and Printing Time Column
when i scrap it scrapes all the 17 columns and yet only need to scrap Document Column and Printing Time Column
Initially if we select the first cell if will ask to whether to take the entire table with YES or NO option
In that choose NO and then we can select the column we want explicitly
select next to extract second column.
Yah please go ahead choosing the next column
For more details on the steps involved
Awesome that we won’t be able to do it hear
First let us get this as a datatable and then we can filter using FILTER DATATABLE ACTIVITY where pass this datatable variable as input and in the condition mention as Starts with and in the value mention as “HC” and get the output with same datatable variable name been mentioned
Followed by this use FILTER DATATABLE ACTIVITY
AND try with these steps
here in the filter datatable mention the input datatable as the one that we got from EXTRACT STRUCTURED DATA activity and in the output datatable field also mention the same datatable name, we dont need to create new datatable buddy
–and in the filter conditions along
column name mention it “your columnname” within double quotes
in condition mention as “Starts with”
and in the value field mention as “HC”