Challenge #371: Generate Corporate Email Addresses

[AYXAcademy]

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:

1. First Name
2. Last Name
3. Email Address

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.

[PhilipMannering]

Here is the solution...attached.

Spoiler

Python Tool,

Spoiler

[mmontgomery]

Challenge 371

Spoiler

[Kenda]

Spoiler

[benjimoser]

My Solution

Spoiler

[RolandSchubert]

Spoiler

[ahsanaali]

Intermediate solution is attached. Followed the instructions regarding ID convention hence answer are bit different compared to the one provided.

Spoiler

Advanced solution

Spoiler

[binuacs]

Spoiler

[Flo_P]

Spoiler

My solution:

[TimJVR]

Spoiler

Including Advanced Solution