This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!
Be sure to review our Idea Submission Guidelines for more information!
One of the common things that I find myself doing is to create a random data-set to learn a tool or to test a theory or to build an experiment; or to load-test a flow.
It would be helpful to have a data generator input that allows you to specify some attributes, which then allows you to generate randomized outputs:
- For Int: random between X and Y; with Z rows
- For dates: random between X and Y; with z rows
- for strings; random strings of length X; with z rows; with selectors to allow for letters; whitespace; numbers; and invisible (e.g. control) characters
This would really make it very rapid to whip together data to test a process
Have you explored the Generate Rows tool? It can be configured to do each of the items you called out. There is an Example of this tool in action from the tool palette. Click on the Generate Rows tool and click "Open Example."
Hope this helps!
Hi Tara ( @TaraM)
Thank you for the reply - I have attempted to do this using the GenerateRows tool - however I wasn't able to see how to both use GenerateRows to generate a rowcount type concept but also to generate random values within ranges.
I've attached a screenshot from an example I've whipped together in a simple workflow (sorry I didn't attach it - I can't figure out how to attach workflows to ideas since there's no browse button on the reply)
If I've missed something in the capability of GenerateRows to do this - that would be very exciting to find this additional capability, so if you can point me to an example it would be well appreciated.
This is similar to what @MattD mentioned in his post about #Santalytics - (https://community.alteryx.com/t5/Engine-Works-Blog/SANTALYTICS-Part-2-Solution-and-Behind-the-Data/b...) where Mockaroo.com was used to create realistic looking test data.
this seems like a very useful capability for Alteryx to have - both for the production of data to test a workflow, but also to produce data to test a down-stream visualization. And - we could start simple - random int; double; date; date-time.
FYI James Dunkerley has built a random number generator tool that supports various distributions in https://jdunkerley.co.uk/2017/04/18/alteryx-omnibus-v0-5-2-jdtools-is-dead-long-live-the-omnibus/. I'd built my own in a couple of hours, but his is better. :)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.