Skip to main content

Posts

Showing posts from February, 2019

Regression Suite Automation Tool - Create unique values

The RSAT doesn't have any roll back feature. So, it can be frustrating updating the excel file with unique records. Well not to worry - RSAT supports Excel formulas. The user guide suggests using RandBetween(a,b) Excel function. However, that isn't really reliable and you are hoping you don't get the same random number. I have been using date formula. The below concatenates the datetime to the string. =CONCATENATE("SS",TEXT(NOW(),"yymmddhhmmss")) If you want to get started with RSAT. Download the tool and the user guide from here. https://www.microsoft.com/en-us/download/details.aspx?id=57357 You can also watch a short video that walks you through how to use it.