2022: Week 20 - TC22 Session Attendance
Challenge by: Jenny Martin It's time for TC22 and in celebration of the hybrid virtual and in person conference this year we're bringing you a TC themed challenge! We want to compile a list of those who were unable to attend the sessions they registered for. If you're new to the Preppin' Data challenges then welcome! We've included some extra hints for this challenge to help you get started, and would recommend going back to the beginning of the year for some more information about what Preppin' Data is all about. Inputs We have 4 input datasets for this challenge: Registrations Sessions Lookup Table Online Attendees In Person Attendees Requirements Input the data In the Registrations Input, tidy up the Online/In Person field ( hint ) From the Email field, extract the company name ( hint ) We define the company name as being the text following the @ symbol, up to the . Count the number of sessions each registered person is planning to attend ( hint )...