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.
1. I chose to split the field1 (containing the name, gender and frequency) into columns 2. Clean up with a select 3. Tokenize the file name to pull out the date 4. Another clean with the select tool 5. Find the top names based up year and gender 6. Separate the genders and join them together based upon the year