Data scrapping and look up data from data table and make click as dynamic

Learning Initatives Automation Starter
, ,
1

Hi all,

This is my data scrapping data and from this i need to look up the MRO GLOBAL PDF,
Tax Invoice B’ Bats.
If either of this are getting in data scrapping we need to fetch and variable need to pass in click.
How to do using look up datatable or regex.

Please help me.

Thanks,
Lakshmi

2

I’m not sure what is your requirement, can you be more explicit ?

Regards,
Cristian

3

hi @cristian_toma ,
Data scrapping result stored in excel .
Need to pick and perform click on sap screen.

How to make click as dynamic.
Please help.
Thanks,
Lakshmi

4

Hey @lakshmi.mp

If you know your exact value to search for then please use Lookup Data Table which will help you to get the actual string into the variable and then it can be passed to the Click’s selector.

Hope this helps.

Thanks
#nK

5

Hi @Nithinkrishna ,

How to pass multiple values into look up data table.

Regards,
Lakshmi

6

Hi @Nithinkrishna , @cristian_toma

How to click in a table based on another column.
If specific data present in column “Name” then it should click, above image highlighted with yellow.
Please help me
Able to fetch the data but not performing click.
Getting error selector not found.

Thanks,
lakshmi

7

Hey @lakshmi.mp

Could you please show us your click selector?

Thanks
#nK

8

Hi @Nithinkrishna ,

Issue resolved I made few changes in my selector. Now its working.
Thanks for replying.

Thanks,
Lakshmi

1 Like
9

Cool @lakshmi.mp

If you are willing to post the solution, then it will help the community.

Thanks

10

Hi @Nithinkrishna ,

Sure.
First perform data scrapping and then store the scrapped data in to excel.
Then for fetching the required data use regex.
After fetching data from regex, pass the variable of regex into look up data table and create variable in row index property.
Pass the row index variable in click, and that will make the click as dynamic.

Thanks & Regards,
Lakshmi

1 Like
11

Cool thanks for sharing. :slightly_smiling_face::+1:

1 Like