Hi all can someone help me make this click activity into dynamic to click based on the case number. im trying to focus on the table called eligibility records. trying to make it select the row that contains the right case number, which is reads off of an excel sheet. Please help.
->Use the Read Range Activity and read the entire Excel sheet and store that data in an data table variable. Output → dt_Extracted.
→ After Read Range Activity use for each row in datatable activity to iterate the each row in the datatable.
→ Inside for each insert the If condition to check the condition
-
Condition -> Currentrow(0).toString.equals("Option to select")
→ Inside If condition insert the assign activity to store the value in a String datatype Variable
called as Str_option. -
Assign -> Str_option = Currentrow(0).toString
→ After assign activity use the click activity and select one option from the dropdown, when indicating the element check the strict selector and uncheck the fuzzy and image.
→ Open the properties of click activity and open the strict selectors and open the Ui explorer and select the attribute which contains the option value, replace the value with Str_option variable and validate.
->Here I have taken the CurrentRow(0).toString.
The column index starts from 0.
A refers to 0
B refers to 1
C refers to 2 and so on
So please change the number 0 according to the index you required.
Regards
Anil_G
ashokkarale
kouhei_yamaguchi
ppr
Nabin_Timalsina
sharazkm32
banksmegacorp
alexis.mendoza.rpa
m.takamiya
Honda