Regarding Data Driven Testing

[NehaLadani]

Hello, 
I reaching out to you for Data Driven Tests.
I have one Excel file as a Data Source with 2 worksheets in that.
I need to enter both worksheet data while sending a payload.
Is there any way that we can get 2 worksheets on board simultaneously?

[ChrisAdams]

Hi,

I cannot readily think of a solution with ReadyAPI here.  You can have two datasources in a test, but the 'inner' would run per row of the outer, but that doesn't sound like what you want.

You might find it easier to use Excel to create a sheet that pulls in the values from the two sheets of interest and then use the new sheet as your datasource.

[SarahS]

It's possible to do this by referencing the row of data you want to target and use a script or some counter in your test case when referencing values from the second data source. You would use the following format to pass those values in. 
${DataSouceTestStep#DataSourceProperty::RowNumber}

Alternatively, it might be quicker to combine the two sheets of data into a new sheet in excel. 

[NehaLadani]

Can you please share the detail of how and where to add this ${DataSouceTestStep#DataSourceProperty::RowNumber}?

[SarahS]

Sure, the details are at the bottom of the resource page for the Data Source Test Step. 

https://support.smartbear.com/readyapi/docs/functional/steps/data-source.html