Generate Synthetic Data

Question

Hi Team,

I have a requirement where in we need to generate massive amounts of synthetic data for a particular data model. We have the range values, expected field calculations etc with us.

I expect to generate over a 1B records. Is this achivable with Alteryx ?

JohnJPS · Accepted Answer

Sounds like a lot of data, but in general, yes, Alteryx is great for generating random data sets.

Use a "Generate Rows" tool to generate as many rows as you need; then a Formula tool to generate random data for whatever you need.  Use the Math > RandInt(n) or Math > Rand() Functions in your Formula Expression.

If you have ranges, something like [RangeBeginning] + RandInt([RangeEnd] - [RangeBeginning]) will give you an integer in your range.

jdunkerley79 · Accepted Answer

I have attached a sample generator I did for another question on here.

The easiest way to do a range is

Rand() * ([Upper]-[Lower]) + [Lower]

JohnJPS · Accepted Answer

[Edit: removing duplicate solution - same as @jdunkerley79's]