![]() ![]() But now it is a daily ritual.isn't that amazing. u201cSomeone asked ChatGPT if it had a Signal. Now creation of functional test cases was a cake walk and believe me that was the first time excel was used in our company for such purposes. However, for some reason, the app gave out a seemingly random phone number which just so happened to belong to Lee. Within an hour, I was able to create a data of 40,000 loan applications having sufficient variety to satisfy the testing requirement. In such scenario, excel proved to be a "god sent" for us.įor customer name I took name from popular Baby Name sites / Indian God Names etc., used random numbers and vlookup and concatenate funtion to change surnames, initials etc (so that one name can be used multiple times by changing surname / initial etc.)įor other columns, again randbetween, Vlookup / Hlookup and concactenate functions proved handy. rphonenumbers(10) rphonenumbers(10, usehyphens TRUE) rphonenumbers(10. We needed following columns:Ĭustomer Name, Date of Birth, Loan Product, Branch Location, Approved Amount, Disbursement Amount, Loan Tenure, sourcing agent etc. A character vector of n randomly generated phone numbers. Being a business analyst (from banking background) and Having used excel to create test data in the similar manner, as you mentioned in your post, I think excel is a wonderful tool for ceating tesing data.įor example, for an application related to a loan management, my development team needed a sizeable data for testing. ![]() ![]() I have been a regular visitor to your blog and getting benefitted by the info posted by you and others.Īm glad you highlighted the use of random numbers for testing. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |