Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Create Sample data using Alteryx

tjamal1
8 - Asteroid

Hello,

 

I am trying to create sample data for the Student Support Ticket using Alteryx

based on the following sample table

 

TicketIDStudentSupportStatusDateTime
11To Do DateandTime
11In Progress  
11Resolved 
21To Do  
21In Progress  
31To Do  

 

Each student can have one or more ticket (TicketIDs).

 

1) Some Ticket have completed their 3 states life cycle 

2) Some tickets have To Do and Inprogress status only

3) Some tickets are in To-Do status now.

4) Date-Time for ToDO can be any DateandTime 

5) But for In-Progress => ToDO DateTime + any random hours

                Resolved => InProgress DateTime + any random hours

 

* I want to create the above sample data for multiple students

 

 

4 REPLIES 4
pedrodrfaria
13 - Pulsar

Hi @tjamal1 

 

What is the size of the data you want to create? I personally would definitely recommend you to use Mockaroo.com instead of using Alteryx to create a dataset, it will be much faster in my opinion, as using Alteryx will require many Generate Rows, Formulas e Multi-Row formulas.

tjamal1
8 - Asteroid

500 Records Max

# of Students IDs can be 5 to 20.

pedrodrfaria
13 - Pulsar

https://www.mockaroo.com/ will definitely be a better solution for you. I definitely recommend you to not waste time trying to do this with Alteryx, you will probably spend a lot of time when in comparison you would spend only a couple of minutes over there. It is free, you can also save the schema you created if you needed to create a larger sample size.

tjamal1
8 - Asteroid

Hi

Thank you @pedrodrfaria for the suggestion, I will definitely give it a try. 

Labels