This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a table which contains first name like this
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)
Go to Solution.
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.
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?
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.
I hope this helps your purpose and meets the expectation. If there is still anything specific you are looking for please reply back.
Thanks for the help , really appreciates the help.
Have a good Day ! 🙂
Great it worked out.
You are welcome. Always happy to help : )
You to stay safe and a great day 😀