Data Driven testing from Excel

Product Forums Katalon Studio
,
1

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.

Switched%20to%20different%20sheet%20and%20came%20back%20to%20same%20sheet%20-%20Variable%20binding%20cleared-%20Forced%20user%20to%20set%20again
Switched%20to%20different%20sheet%20and%20came%20back%20to%20same%20sheet%20-%20Variable%20binding%20cleared-%20Forced%20user%20to%20set%20again781Ă—482 16.6 KB

2

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

1 Like
3

thank you for your reply.It worked.

4

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