I want to use data driven testing. For this I keep data in excel file. For example, I have sheet Person with the following columns and rows:
Id| Name | Surname | Age
------------------------
2 | Mike | Black | 25
3 | Bob | Tuck | 23
Now, every person has 0..N cars, and every car has model, number and color. How to add these data about cars? Should I create extra sheet with cars and add column Cars to Person and to list all cars of the person by id:
Id| Name | Surname | Age | Cars
--------------------------------
2 | Mike | Black | 25 | 14, 20
3 | Bob | Tuck | 23 | 5
Or maybe there are better ways?
Aucun commentaire:
Enregistrer un commentaire