topic Practice Exercise 2 - Learning Path 1 in Practice Exercise https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/1276801#M36603 <P>.</P> Fri, 24 May 2024 11:17:27 GMT Ahmad_Yassin01 2024-05-24T11:17:27Z Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/474129#M8 <P style="text-align: center;"><FONT size="4">Congratulations on completing Exercise 2!&nbsp;</FONT></P> <P style="text-align: center;">&nbsp;</P> <P style="text-align: center;"><FONT size="4">When you are ready to submit your solution, click "Reply" to this post and upload your workflow. </FONT></P> <P style="text-align: center;">&nbsp;</P> <P style="text-align: center;"><FONT size="4">You may also download and review the attached solution.</FONT> </P> Fri, 29 Sep 2023 11:21:49 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/474129#M8 AYXAcademy 2023-09-29T11:21:49Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/475274#M22 Thu, 10 Oct 2019 19:36:51 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/475274#M22 blundebjerg 2019-10-10T19:36:51Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/475527#M26 <P>It was easy even for me! <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P> Fri, 11 Oct 2019 10:28:12 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/475527#M26 Alejandro 2019-10-11T10:28:12Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/475792#M30 Fri, 11 Oct 2019 19:12:17 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/475792#M30 Snare 2019-10-11T19:12:17Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/476557#M37 Tue, 15 Oct 2019 05:01:25 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/476557#M37 swapnil123 2019-10-15T05:01:25Z Re: Learning Path 1: Exercise 2: Solution for Practice Exercise 2 https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/476565#M38 <P>Solution for Practice Exercise 2&nbsp;</P> Tue, 15 Oct 2019 05:55:39 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/476565#M38 kiran3 2019-10-15T05:55:39Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/477276#M49 Wed, 16 Oct 2019 20:18:15 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/477276#M49 Jzuniga7 2019-10-16T20:18:15Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/477901#M61 <P>Here's my workflow.</P> Fri, 18 Oct 2019 07:00:06 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/477901#M61 Aastha 2019-10-18T07:00:06Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/478130#M68 Fri, 18 Oct 2019 16:58:54 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/478130#M68 Elysia1 2019-10-18T16:58:54Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/478402#M71 Sun, 20 Oct 2019 12:04:16 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/478402#M71 CristinaTudoran 2019-10-20T12:04:16Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/478629#M77 Mon, 21 Oct 2019 11:33:41 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/478629#M77 Rinshad 2019-10-21T11:33:41Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/478752#M80 Mon, 21 Oct 2019 15:24:38 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/478752#M80 sarahjohnson 2019-10-21T15:24:38Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479099#M84 Tue, 22 Oct 2019 10:46:37 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479099#M84 Odwyer 2019-10-22T10:46:37Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479157#M85 Tue, 22 Oct 2019 12:54:11 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479157#M85 jeng 2019-10-22T12:54:11Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479464#M92 Tue, 22 Oct 2019 20:53:19 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479464#M92 madeleineK 2019-10-22T20:53:19Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479524#M94 Wed, 23 Oct 2019 02:00:53 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479524#M94 MFish 2019-10-23T02:00:53Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479660#M97 Wed, 23 Oct 2019 11:21:40 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479660#M97 PhilippK 2019-10-23T11:21:40Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479823#M102 <P>Some assumptions need to be made for this exercise. One, customer entries are not unique at the annual transaction level so I average the two. Also, Not all customers contain user details so i thought including all data even where user details are not available would be valuable with a additional union after the join on sale and customer join.&nbsp;</P><P>&nbsp;</P><P>P.S. pipes are (Shift+\), not (ctrl+\).&nbsp;</P> Wed, 23 Oct 2019 15:45:27 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479823#M102 jstewart 2019-10-23T15:45:27Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479863#M105 Thu, 24 Oct 2019 16:27:31 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/479863#M105 JeffS 2019-10-24T16:27:31Z Re: Learning Path 1: Exercise 2: General https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/480186#M114 Thu, 24 Oct 2019 12:03:14 GMT https://community.alteryx.com/t5/Practice-Exercise/Learning-Path-1-Exercise-2-General/m-p/480186#M114 RogerL 2019-10-24T12:03:14Z