Test Data Manager

Hi All, 

i am looking for following functions in Data Maker 

1) random Decimal number with decimal precision

2) casting functions from one data type to other 

3) formatting functions for Date, date time or time stamp.

Please help me if we have any such functions. 

Hi Raju,

There are multiple ways of generating what you are looking for. These are just examples.

For more information on these functions, please refer to the documentation at:

Data Generation Functions and Parameters - CA Test Data Manager - 3.8 - CA Technologies Documentation 

1) random Decimal number with decimal precision

You could use something like @randrange(2,300)@.@randrange(2,40)@

You may also use the STRING(NUMBER, NUMBERFORMAT) function. For example, @string(@randrange(1,30000)@,0.00)@

2) casting functions from one data type to other

Typically, Datamaker will take care of casting functions to the appropriate data type (depending on the data type of the column). If you do face issues however, please open a support case.

3) formatting functions for Date, date time or time stamp.

You may use string(date,dateformat) which will return the date in a specific "dateformat". For example,

@string(~CDATE~, YYYY-MM-DD)@

Please review the documentation. If you feel there is a function that is missing and you would like added to the product, please submit an idea on the communities under category "CA Test Data Manager" and provide examples and business need. Product Management will then review it and make a decision on whether it could be added to an upcoming release.

Thanks,

Sameer 

Thanks Sameer.