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)
Solved! Go to Solution.
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 : )
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?
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 : )
Thanks for the help , really appreciates the help.
Have a good Day ! 🙂
Stay Safe
Great it worked out.
You are welcome. Always happy to help : )
You to stay safe and a great day 😀
Cheers and Happy Analyzing : )