Wednesday, 20 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.

2 comments:

Alicja Filipowicz said...

A very interesting entry! You can see that you know a lot about this topic :) I'm new to this topic and I am thinking about the implementation of aws cloud solutions ( about aws here). What do you think about it? Do you recommend people to use such solutions? :) I'm wondering if it's a good idea :)

Sanjay Chandrasekar said...

Great Post!
Is reverting data in RSAT tool is not possible ? Regards, Sanjay.C