Test ID for Excel or other Data Driven

3 posts, 0 answers
  1. Herb
    Herb avatar
    18 posts
    Member since:
    Jul 2013

    Posted 15 Jul 2013 Link to this post

    I'm trying to find a way to assign TEST Scenario ID's to Data rows to drive different test scenarios.   Everything I read is that I'm limited to Rows X-Y or the entire table/sheet.

    I would like the capability to define a TEST Id to a row to only use that row to data drive the test. 

    I have several test templates created that build out my Test Scenario.   These access multiple excel worksheets with data, however I don't want Test Scenario X to run Test Scenario Y tests data.

  2. Cody
    Cody avatar
    3354 posts

    Posted 15 Jul 2013 Link to this post

    Hello Herb,

    Would you be willing to put your test data into a SQL database? Then you can use T-SQL queries to pull the data for that specific test as demonstrated near the bottom of this page:

    In your case include a WHERE clause to limit the data pulled that matches only the a specific scenario ID.

    We've released our first-ever public Test Studio BETA! Download the BETA, install it,
    and send us your feedback! Expires mid-August!
  3. Herb
    Herb avatar
    18 posts
    Member since:
    Jul 2013

    Posted 16 Jul 2013 Link to this post

    Yes, I think something like this can work.   I will give it a try today.
Back to Top