Challenge #1: Join to Range

[jaiswas1]

- I did split the Range into columns from 2nd Input file with Text to Column tool.

- Changed Datatype and Removed unwanted columns with Select Tool.

- Generated years from Range with Generate Rows tool.

- Then Joined the First input file and the Generated Rows output.

- Finally used the summarize tool to count the customer ID by doing the group by on Region, Responder and Sales Rep.

Attaching the solution approach.

[varunvarma87]

Challenge 1 completed !

Spoiler

[CharlieScammell]

Week 1: Complete

Spoiler

[alishapaul]

I didn't use the generate rows tool because I wasn't really familiar with it.

But this was a good opportunity to learn it! Thanks!

Spoiler

 

[scotthall]

My solution to #1.

Spoiler

SPOILER:

[husainamjhera]

I am a bit late into the party!!

Tried my best

[rrenu59]

I'm learning Alteryx by watching YouTube videos and solved my first challenge. Very much excited for the coming challenges...Great way to learn Altryx through practice Exercises.Thank you so much !!

[dylan_gao]

Ok, here come my weekly challenge journey!

Spoiler