Working with unique values

Ask general questions here.
Posts: 10
Joined: Tue Jun 25, 2013 2:13 pm

Working with unique values

Post by peterbonney » Tue Aug 19, 2014 10:16 am

Hi All,

I have a field that requires a unique value for each iteration, the obvious answer is to data drive this field.
However, this value is written to the database, and its not going to be always possible to clear the DB down before each run. I was wondering if it is possible to use formulas in a spreadsheet used to data drive tests?

If so i can just prefix or suffix my unique field with the date e.g

In Excel formula =Today() tc1
resulting in
19/08/14 tc1
19/08/14 tc2
19/08/14 tc3

and so on.

any help/advice would be greatly appreciated


Posts: 2683
Joined: Tue Feb 07, 2012 4:14 pm
Location: Austin, Texas, USA

Re: Working with unique values

Post by krstcs » Tue Aug 19, 2014 1:18 pm


Yes, you can use formulas in your Excel data.

You could also create a user code method that creates the unique data for you at run-time by adding the date/time to the value right before you use it in your test.
Shortcuts usually aren't...