Congratulations on completing Exercise 1!
When you are ready to submit your solution, click "Reply" to this post and upload your workflow.
You may also download and review the attached solution.
Every journey begins with a single step.
Here you are!
Glad that getting basic information about alteryx designer for free. It is really a very good and user friendly tool for beginner. Anybody who wants to learn about ETL should start from alteryx.
Done
Please find attached
attached
I noticed, that the name of the column "TransInYear" in Start changed to "Annual Transactions" in Final State, The exercise does not asked for it so I did not changed the name with the Select tool in the Rename column.
Solution to the first exercise.
Select - remove Weekly Sales and Store Volume columns
Filter - Region = South
Sort - descending transactions year
sample - first 5 rows
my practice + exercise.
My Solution
Solution
solution for exercise 1
1.Filter them based on region
2. Sort Descending based on Transactions
3.Use select to drop the specific columns
4.Sample the first N rows
Completed the first practice exercise
Solution attached.
answer to the question
Completed
Resualt
My first post in Alteryx community, let's go!
Please see attached Solution workflow for Practice test 1.
Hi
PFA my solution
.
