Practice Exercise

Learning Path 1: Exercise 1: General

awood7
5 - Atom

Avery Wood

Emmalynae23
5 - Atom

Practice Exercise 1 for Topics in Accounting 2/25/19

mjude01
Alteryx Alumni (Retired)
 
tbundy
5 - Atom

Tom Bundy

Alexander714
5 - Atom
 
ngiletto
5 - Atom
 
wvumtneer
5 - Atom
 
andrericca19
5 - Atom

Attached

MA66
6 - Meteoroid
 
victorlongo
5 - Atom

Steps to solve problem:

1) Use the SELECT tool to drop "Weekly Sales" and "Store Volume" columns

2) Use the FILTER tool to choose rows where [Region] equals South by using the Basic Filter.

3) Use the SORT tool do sort TransInYear in Descending order (highest Transactions average first). ATTENTION: The T (True) output from the Filter tool should be connected to the Sort tool, not the F (False).

4) Use the SAMPLE tool to select "First N rows" sample type and set N = 5.

5) Run the Workflow and compare your Sample tool output with the Final state results.