Extract latest date from webtable

Learn Academic Alliance
1

Hi team,
the webtable consist of a column link to download the form but there might be a possiblity that there are two links present so in that case BOT will be checking the date column and on the basis of highest/latest date will be clinking in the link column to download the form.
Can anyone help to bulid this logic.

Thanks,
Zara

2

Hi @Zara

For this use webscrapping to scrape the entire webtable and then based on datatable manipulation check for latest date and corresponding to that date take the link use download that form which is present in datatable

Hope u got the logic what I had told

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed:

3

can u please share the sample of logic?

4

Can I have a weblink to show that demonstration? @Zara

5

apart from weblinkā€¦u can take any string and store it into variableā€¦in real workflow iā€™ll replace it with clickā€¦
that if more than one row is present in datatable then click in the column corresponding to highest date in the date column
@c.ciprian can u pls help

6

Can u Share the screenshot of webtable @Zara

7

Hi Zara,

You have to perform following steps to achieve this.

1- Scrap the data of web page with data scraping activity including date column as well where all the dates are showing ok. It will give you data table.
2- Now you need to add query on data table to find the latest date ok.
[YourDataTableName].AsEnumerable().Max(Function (drRows) DateTime.Parse(drRows.Item(ā€œDateColumnNameā€).ToString)).ToString
3. It will give you the latest date then use ā€œget attributeā€ activity and in the selector add that date and get table row. it will return table row.
4. Pass that table row inside the click activity selector of ā€˜Download columnā€™ of the table.

Just try it you can do it.

Hope it will work

1 Like
8

heyā€¦do u have any test xamlā€¦that i can quickly integrate?
i will make changes in the selector partā€¦pls

9

give me the url where you want to perform this.

I will create a work flow.

I did this in one use case but my workflow will not run on your laptop cuz data scraping will not work on your laptop/ pc because of selector issue and url also will not open, i am doing many things in it so share me url i will create workflow.

10

URL wonā€™t open for uā€¦
U can share the workflow with activities ā€¦i will ammend into mine

11

ook let me create a workflow.

12

pleaseā€¦thank youā€¦

13

I have added log messages indie the workflow it will help you to understand the code and you can make it dynamic according to your requirements .

Let me know in case of any issueDownloading_File_With_Latest_Date.xaml (11.4 KB)

1 Like
14

will this work for date in the format ā€œ7/15/2020ā€ ?

15

You can set the date according to the format given on the web page.

Do you have skype? You can share your screen with me i will fix this
ghazanfer.ali75

16

Uipath is throwing error because column name is ā€œDate Submittedā€ and it is considering Date as a function in datacolumn because of which while passing the query it is throwing error ā€œDate columnā€ does not belong to table

17

Because you are setting the name of the date column different in the scraping and in the query it is different.
Make sure both are same

18

yeah i am giving Date Submitted only

19

then write ā€œDate Submittedā€ in the query as well in the column name

20

i just wrote query and try to fetch the result in logā€¦but it is throwing error in the assign onlyā€¦where i am passing the query