2.4 Sample

Alteryx Essentials Data Preparation
1 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$49.99
List Price:  $69.99
You save:  $20
€42.53
List Price:  €59.54
You save:  €17.01
£36.81
List Price:  £51.54
You save:  £14.73
CA$69.03
List Price:  CA$96.65
You save:  CA$27.62
A$75.57
List Price:  A$105.80
You save:  A$30.23
S$64.01
List Price:  S$89.62
You save:  S$25.60
HK$389.24
List Price:  HK$544.98
You save:  HK$155.73
CHF 39.67
List Price:  CHF 55.54
You save:  CHF 15.87
NOK kr498.32
List Price:  NOK kr697.69
You save:  NOK kr199.36
DKK kr317.57
List Price:  DKK kr444.63
You save:  DKK kr127.05
NZ$83.94
List Price:  NZ$117.53
You save:  NZ$33.58
د.إ183.58
List Price:  د.إ257.03
You save:  د.إ73.45
৳6,081.69
List Price:  ৳8,514.86
You save:  ৳2,433.16
₹4,406.72
List Price:  ₹6,169.76
You save:  ₹1,763.04
RM210.25
List Price:  RM294.37
You save:  RM84.12
₦75,331.93
List Price:  ₦105,470.73
You save:  ₦30,138.80
₨14,140.22
List Price:  ₨19,797.45
You save:  ₨5,657.22
฿1,582.93
List Price:  ฿2,216.23
You save:  ฿633.30
₺2,062.63
List Price:  ₺2,887.85
You save:  ₺825.21
B$271.02
List Price:  B$379.45
You save:  B$108.43
R872.93
List Price:  R1,222.17
You save:  R349.24
Лв83.06
List Price:  Лв116.29
You save:  Лв33.23
₩69,266.95
List Price:  ₩96,979.27
You save:  ₩27,712.32
₪166.71
List Price:  ₪233.41
You save:  ₪66.69
₱2,843.40
List Price:  ₱3,980.99
You save:  ₱1,137.59
¥7,322.04
List Price:  ¥10,251.45
You save:  ¥2,929.40
MX$929.42
List Price:  MX$1,301.27
You save:  MX$371.84
QR182.03
List Price:  QR254.86
You save:  QR72.82
P667.26
List Price:  P934.22
You save:  P266.95
KSh6,458.70
List Price:  KSh9,042.70
You save:  KSh2,584
E£2,398.08
List Price:  E£3,357.51
You save:  E£959.42
ብር7,111.06
List Price:  ብር9,956.05
You save:  ብር2,844.99
Kz45,588.63
List Price:  Kz63,827.73
You save:  Kz18,239.10
CLP$48,443.30
List Price:  CLP$67,824.50
You save:  CLP$19,381.20
CN¥356
List Price:  CN¥498.43
You save:  CN¥142.43
RD$3,152.87
List Price:  RD$4,414.27
You save:  RD$1,261.40
DA6,481.50
List Price:  DA9,074.62
You save:  DA2,593.12
FJ$112.04
List Price:  FJ$156.86
You save:  FJ$44.82
Q383.16
List Price:  Q536.45
You save:  Q153.29
GY$10,454.61
List Price:  GY$14,637.29
You save:  GY$4,182.68
ISK kr6,099.27
List Price:  ISK kr8,539.47
You save:  ISK kr2,440.20
DH451.34
List Price:  DH631.91
You save:  DH180.57
L828.54
List Price:  L1,160.02
You save:  L331.48
ден2,615.10
List Price:  ден3,661.35
You save:  ден1,046.25
MOP$400.06
List Price:  MOP$560.11
You save:  MOP$160.05
N$875.74
List Price:  N$1,226.11
You save:  N$350.36
C$1,833.46
List Price:  C$2,566.99
You save:  C$733.53
रु7,014.83
List Price:  रु9,821.33
You save:  रु2,806.49
S/175.76
List Price:  S/246.08
You save:  S/70.32
K210.10
List Price:  K294.16
You save:  K84.05
SAR187.52
List Price:  SAR262.55
You save:  SAR75.02
ZK1,194.75
List Price:  ZK1,672.74
You save:  ZK477.99
L215.78
List Price:  L302.11
You save:  L86.33
Kč1,034.19
List Price:  Kč1,447.94
You save:  Kč413.75
Ft16,724.66
List Price:  Ft23,415.87
You save:  Ft6,691.20
SEK kr467.96
List Price:  SEK kr655.18
You save:  SEK kr187.22
ARS$71,136.08
List Price:  ARS$99,596.21
You save:  ARS$28,460.12
Bs346.54
List Price:  Bs485.18
You save:  Bs138.64
COP$198,845.49
List Price:  COP$278,399.60
You save:  COP$79,554.10
₡25,201.42
List Price:  ₡35,284.01
You save:  ₡10,082.58
L1,307.97
List Price:  L1,831.26
You save:  L523.29
₲359,195.38
List Price:  ₲502,902.28
You save:  ₲143,706.89
$U1,997.91
List Price:  $U2,797.24
You save:  $U799.32
zł180.90
List Price:  zł253.28
You save:  zł72.37
Already have an account? Log In

Transcript

The sample tool allows you to select a subset of rows in your data. This tool is useful if you need to just see, for example, the first record in your data set, the first 10 Records 10% of all records or every 10th record in your data set. As illustrated in the slide here. The first picture is our example HR data set. The second is where we've included our sample tool, and I've selected one out of every five records. And the last picture shows the outputs of that sample.

Let's start a new workflow by importing spreadsheet 2.4. We'll go to the Insert tab, drag in the input data tool and connects to 2.4 sample. We again have our HR file with 30 employees. So now we'll go to the preparation tab and drag in the sample tool In the configuration menu on the left, we have several sampling options. If we go to the middle and update n equals 100 to n equals 10. We can now choose to sample the first 10 rows in our data set the last 10 rows.

Skip the first 10 rows ensure everything else. Show one out of every 10 Records. Have a one in 10 or 10% chance to include each row or only show the first 10% of all records in the data set. Select each of these one by one and press the run workflow button or Ctrl R to familiarize yourself with the outputs of each option. I've selected the first 10 rows here. Therefore the first 10 records have appeared in the preview pane.

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.