ETL and Data Integration tools - Modern ETL software for everyone

Hi.
Apologies in advance if this issue has been addressed in the forum - ran a search but found no threads. This is a presales question.
Can I insert a random long integer into my destination table with each row that I import from an Excel spreadsheet?

Rob Roy

Rob

Sure it is possible. Plus, if something is missing we are happy to add it for you

RandomRange returns a random integer from the range that extends between AFrom and ATo (non-inclusive). RandomRange can handle negative ranges (where AFrom is greater than ATo). To initialize the random number generator, add a single call Randomize

RandG produces random numbers with Gaussian distribution about the Mean. This is useful for simulating data with sampling errors and expected deviations from the Mean.

Mike