Forum Discussion

vondie's avatar
vondie
Contributor
9 years ago

Data Driven Loop with Image Link Variables from Excel

I currently have a Data Driven Loop set up to run through a variety of different variables from an Excel file. I have a step in the loop test that requires clicking an image object to go to the next ...
  • vondie's avatar
    vondie
    9 years ago

    I figured out a way to accomplish my task without using the FindChild method by using a series of nested If...Then statements.

     

    The logic looks like this: 

    If... [spreadsheet lists this word]

         then... click this object.

    Else

          If... [spreadsheet lists this other word]

                 then... click this other object...

          Else

                 return

vondie's avatar
vondie
Contributor
9 years ago

I figured out a way to accomplish my task without using the FindChild method by using a series of nested If...Then statements.

 

The logic looks like this: 

If... [spreadsheet lists this word]

     then... click this object.

Else

      If... [spreadsheet lists this other word]

             then... click this other object...

      Else

             return

  • djadhav's avatar
    djadhav
    Regular Contributor
    9 years ago

    vondie, I am glad you were able to make it work.

     

    The few advantages of using FindChild are,

    1) You can add, edit and update the list of image names in excel without changing your script.

    2) As your list grows, this will keep it manageable.

    3) It is better design. Hard coded values in scripts is not a good idea.

     

    But if you don't have too many items, your solution would work perfectly fine as well. Good job.