Generate Random Records for Activity Table

tjamal1

Hello ,

I am trying to create a activity Table for students which consist of these columns and requirements

1 ID (Incremental)

2 Student (001) for one student only

3. Date Column (Any Date)

4. Activity Type (In School , HomeWork , Assessments)

5 Time Spent on Activity with following conditions

i Accumulative Time Spent In-School should not be greater than 25 hours

ii Accumulative Time Spent HomeWork should not be greater than 15 hours

iii Accumulative Time Spent Assessments should not be greater than 8 hours

A Student contains at-least 100 records

Sample Data

ID	Student	Date	Activty Type	Time Spent (in mins)
1	001	10/23/2019	In-Class	60
2	001	10/24/2019	Homework	30
3	001	10/25/2019	Assessments	10

How can i generate records based on above requirements specially point (5)?

Common Use Cases

Help

Accepted answers

danilang

Hi @tjamal1

I added a new multi-row tool configured like this

If it's the first row for this student pick any random day from 2019-10-23 to 365 days after

else increment the previous date by 0-2 days

Dan

RandomActivity v2.yxmd

All comments

danilang

Hi @tjamal1

Here's one way you can do it

Generate the 3 types of activities separately. Each container generates 10000 rows of activity data in multiples of 5 minutes. After the running total, the Multi-row formula assigns a new student ID every time the running total passes a new 25 hour booundary, i.e. 0-1500 minutes is student 1, 1500-3000 is student 2, etc. The boundaries are adjusted in each container according to your requirement 5. Union the three activity types and then count the number records per student and filter to pass only those with more than 100 records. The next join filters only those students. format the student ID, sort and then add the ID field. The results look like this

The workflow generates approximately 100-120 students

Dan

RandomActivity.yxmd

tjamal1

Hi , Thanks for the detailed reply and workflow

I was wondering is there anyway to generate random date between

10-23-2019 and 10-23-2020 for each student

and increment it accordingly so the minimum date of each student should be any random date between 10-23-2019 and 10-23-2020 and increment those dates for each student by any random days

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703