Data Driven testing from Excel

Test data in excel with multiple sheets has been created and variable mapping. Select Test Suite ,Select Test Data from Test data selection with either Add before or Add Later , then under Variable Binding section for the first time we set type,Test data and Value. This feature works great if we have only sheet in excel test data. If we have to switch from sheet 1 to sheet 2 , variable binding is not retaining. I have 10 rows in my sheet. For each run i have to set type, Test data selection ,value for all 10 rows recommendation. Please recommend any other alternative to retain variable binding after selecting corresponding test data.

Rename your column on testData with the name of the variables. Then you only have to click on “Map All”

1 Like

thank you for your reply.It worked.

Can’t we copy the csv data files into katalon Data Files folder.