I have a req where have to run multiple jobs per day and each job has certain data that should be called from master excel sheet.
Instead of providing the data everytime in the excel and importing the excel data to QTP , do I have an option of calling the data from another master excel sheet based on jobID and imported dynamically?
for eg: job -> tables (these table names are called from master sheet(another excel sheet))
once if I provide jobid in my excel it should call the corresponding tables from the master sheet and import them to QTP.
Could you elaborate on this.
Based on what i understood You can use something like this:
An excel having MasterSheet, JobID1Sheet, JobID2Sheet, ...
JobIDsheets will have the list of tables to be imported.
In master you can specify the job to be executed or not :