Forum Discussion

AviDery's avatar
AviDery
New Contributor
7 years ago

Using data source property to load another data source

I'm working with several data layers when testing WS.
In order to use the data correctly I need to get one property from a specific sheet in my data Excel file and then use it as the name of the next sheet to be called.

Can you please tell if and how it can be done?

 

Thank you all in advance.

2 Replies

Sort By
  • IgorG's avatar
    IgorG
    Staff
    7 years ago

    You can use property expansions to get data from the first data source, so you would have 2 Excel data sources in a row and a second one will have Worksheet value along the lines of ${DataSource#sample}

  • sanj's avatar
    sanj
    Super Contributor
    7 years ago

    Can you just nit use Excel sheets and then cells not reference from one sheet to another?