community Alteryx IO MyAlteryx
alteryx Community
Sign Up Sign In
  • English (US)
  • Français
  • Deutsch
  • 日本語
  • Português
  • Español
  • Participate
  • Learn
  • Support
  • Groups & Events
  • Toolbox
  • Alteryx IO
  • MyAlteryx
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close

Sign in. Geek out.

Connect with a community of data science and analytic experts to discover new solutions to complex challenges, contribute fresh ideas, and gain valuable perspective on the rapidly developing industry.
  • Community
  • Community
  • :
  • Albums for Community
  • :
  • Images in Profile (mceleavey)
  • :
  • My Images for mceleavey

My Images for mceleavey

  • Albums
  • All Images
Image Options
  • Flag Image for Review
  • Bookmark
  • Subscribe to RSS Feed

Album: Profile (mceleavey)

by 17 - Castor mceleavey
Create all combinations.PNG
Filter Cmbinations of the same box.PNG
Unique combi.PNG
Filter top picks.PNG
Initial Data Cleanse.PNG
Create Input variable.PNG
Text to columns on designated character and number of columns.PNG
Remove leading zeros.PNG
Isolate 4 Digit Code.PNG
Trim SD from the end of a string.PNG
Trim to 8 Characters and add US.PNG
Isolate 5 digit codes.PNG
Solution.PNG
Solution.PNG
Isolate Codes.PNG
Isolate required rows and split to age groups.PNG
Solution.PNG
Transpose to group.PNG
Create calculations.PNG
three month expression.PNG
Crosstab to regroup.PNG
Join to main body.PNG
Initial split and transpose.PNG
Parse out month strings to record ID.PNG
Parse out day and Year values.PNG
Join together and format dates.PNG
Prepare initial search string for download.PNG
Download and parse.PNG
Cleanup and sorting.PNG
Re-arrange accordingly and rename.PNG
Output.PNG
Solution.PNG
1. Download and parse JSON.PNG
2. Column Header Stream.PNG
3. Data Stream.PNG
4. Pivot Data and dynamically rename.PNG
5. Sort and drop unwanted columns.PNG
Task 1 - Determine Year.PNG
Task 2 - Determine Averages without Zeros.PNG
Task 3 - Determine Average values and totals.PNG
Task 4 - Determine Percentages.PNG
Solution.PNG
results.PNG
results.PNG
Solution.PNG
Challenge 14 Solution.PNG
Challenge 14 Results.PNG
1. Convert and filter dates.PNG
3. Join, sort and pivot.PNG
5. Join and calculate %.PNG
Join together and format dates.PNG
Previous
Join together and format dates.PNG
Next
Added ‎01-23-2017 10:02 AM
0 Likes
Posted in: Re: Challenge #4: Date Parsing - ( ‎01-23-2017 10:02 AM )

You must be a registered user to add a comment on this image. If you've already registered, sign in. Otherwise, register and sign in.

  • Comment
CMX 2021 Community of the Year Winner Badge
Privacy Policy Cookie Settings Cookie Notice Terms and Conditions Version History
© 2025 Alteryx, Inc.
Privacy Policy Cookie Settings Cookie Notice Terms and Conditions Version History