A solution to last week's challenge can be found here.
This challenge comes to us from @randall_king. Thank you for your contribution, Randy!
Use Designer Desktop or Designer Cloud, Trifacta Classic to solve this week's challenge.
Your Human Resources department received a CSV file with the names of all new employees hired for all stores in the last month. They want to create these new employees’ email addresses. The company uses the initials from an employee’s first name and last name to create these emails. For example, Ana Muniz would be assigned AM@organizationname.com. If more than one person shares the same initials, add a number after the second initial. For example, Alan Murphy would be assigned AM1@organizationname.com.
For this challenge, you can provide an intermediate or advanced solution.
For the intermediate solution, use the CSV file to generate the emails using the fixed company domain, organizationname.com. Your output file should contain the following columns:
For the advanced solution, create an app where users can input a specific domain name through an interface similar to the one in the following image , and provide the same output as the intermediate solution.