Forum Discussion

Tonya's avatar
Tonya
New Contributor
8 years ago

How to read more than one value from the DataSource?

Hi,   I need to retrieve 2 values from excel DataSource for each test run.   I created excel document with 2 spreadsheets and want to use two DataSource properties (each should be getting data fr...
SmartBearAmber's avatar
SmartBearAmber
SmartBear Alumni (Retired)
8 years ago

Hello Tonya,

 

To read from two separate sheets, you'll need to create two separate DataSource Test Steps.

  • Tonya's avatar
    Tonya
    New Contributor
    8 years ago

    Actually I need to use both values in one test step. Found simple solution - put second set of values in a column next to the first, in the same sheet. Then it picked it up automatically. Problem solved.

     

    When I tried to put second set of values in a separate document or another worksheet and used two DataSource Test Steps, I could not get a pair of values for one test step. Whenever I put DataSource Loop the test would not go further.

     

    Thanks,

    Tonya