Generate rows based on reference table

Hello,

I have a table which contains first name like this


1           Lisa
2           John
3       Jonathon
4        William
5          Mario
6        Bradley
7         Amanda
8           Cole
9      Christina
10       Shirley
11       Michael
12     Alexandra
13       Patrick
14         Kevin
15        Steven
16         Kayla
17      Kimberly
18        Joseph
19       Michael
20        Nicole

I want create another table containing 1000 records based on these condition

FirstName : Random value from above names

TransactionDate : any random date between 1975 & 1990

Status : Pick random value from these three (Pending , Processed ,Completed)

Is there anyway to do it in Alteryx (an example would be helpful)

Datasets

Help

Accepted answers

atcodedog05

Hi @tjamal1 ,

Here is an approach including assigning random dates.

Apparently generating random dates is not simple generating random number.

Hence have creates a list of dates and used a randomly generated Date ID to join them.

The workflow is attached in the reply.

I hope this helps your purpose and meets the expectation. If there is still anything specific you are looking for please reply back.

If it solves your case study please like the reply and mark the reply as accept solution.

Thank you for sharing this scenario. It was a great exposure.

Cheers and Happy Analyzing : )

Generarte Records.yxmd

All comments

atcodedog05

Hi @tjamal1 ,

Here is an approach to solve your requirement.

I used rows generate tools to generate 1000 rows.

Later used RandInt function to assign random values for 3 columns which included an random Name ID field.

Later i joined the generated rows data and First Name list on Name ID.

Achieved output

The workflow is attached in the reply.

I hope this helps your purpose. If there is still anything specific you are looking for please reply back.

If it solves your case study please like the reply and mark the reply as accept solution.

PS: really appreciate that you were able to provide the file or else it would have been harder to provide solution.

Thank you for sharing this scenario. It was a great exposure.

Cheers and Happy Analyzing : )

Generarte Records.yxmd

tjamal1

Thanks for the detailed reply and solution ,

Is there any we could get date in full format instead of only year ?

like date between 01-01-1975 and 31-12-1990?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703