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.

    Thanks,
    Herb
  2. Cody
    Admin
    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:
    http://www.telerik.com/automated-testing-tools/support/documentation/user-guide/data-driven-testing/bind-test-to-data-source.aspx

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

    Regards,
    Cody
    Telerik
    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