Time Difference and Check Duplicate value

[Himanshu_Pratap_Rana (Robot Master)]

input12.xlsx (8.6 KB)

I have input datatable column(Subject)

Q-1 if get text is match on second datatable table then click on intraday
Q-2 I want the latest report but date is fix but time is different@how to handle this
Q-3 Because after hours duplicate value comes again(600 CIS AUTO: Genius),i do’nt want the duplicate value

[Shaik_Najeer]

Hi @Himanshu_Pratap_Rana

Please help me to understand clearly. I assume that as per your requirement bot should click on the Intraday which in the top of the table based on the value from the input12 table Subject value right.?

I mean you want to deal with the latest row for the input value.?

Thanks,
Najeer.

[Himanshu_Pratap_Rana (Robot Master)]

@Shaik_Najeer -you are right

[Himanshu_Pratap_Rana (Robot Master)]

Any suggestion for this topic

[Shaik_Najeer]

Hello @Himanshu_Pratap_Rana

Yes we can able to do it.

Step 1: extract the whole table From the page And store into data table

Step 2: loop the table to find the input value row index with if condition. If it matches break the loop.
And grab the row number with for each index or by using counter.
(Note: we need row number of first appeared input value in the table)

Step 3: use click activity and click random intraday and in that selector pass the index value which we derived from the data table looping

Hope it works. If you had any discrepancy please write down.

Thanks
Shaik Najeer