Challenge #371: Generate Corporate Email Addresses
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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:
- First Name
- Last Name
- 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Challenge 371
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My Solution
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Including Advanced Solution