Create Sample data using Alteryx

[tjamal1]

Hello,

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

based on the following sample table

TicketID	Student	SupportStatus	DateTime
1	1	To Do	DateandTime
1	1	In Progress
1	1	Resolved
2	1	To Do
2	1	In Progress
3	1	To 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

[pedrodrfaria]

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]

500 Records Max

# of Students IDs can be 5 to 20.

[pedrodrfaria]

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]

Hi

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