2.2 Select

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
€44.13
List Price:  €61.79
You save:  €17.65
£37.44
List Price:  £52.41
You save:  £14.97
CA$69.08
List Price:  CA$96.72
You save:  CA$27.64
A$77.43
List Price:  A$108.41
You save:  A$30.97
S$64.46
List Price:  S$90.26
You save:  S$25.79
HK$387.43
List Price:  HK$542.43
You save:  HK$155
CHF 41.22
List Price:  CHF 57.72
You save:  CHF 16.49
NOK kr518.27
List Price:  NOK kr725.62
You save:  NOK kr207.34
DKK kr329.33
List Price:  DKK kr461.08
You save:  DKK kr131.75
NZ$83.61
List Price:  NZ$117.06
You save:  NZ$33.45
د.إ183.61
List Price:  د.إ257.07
You save:  د.إ73.45
৳6,093.85
List Price:  ৳8,531.88
You save:  ৳2,438.02
₹4,219.04
List Price:  ₹5,906.99
You save:  ₹1,687.95
RM211.08
List Price:  RM295.53
You save:  RM84.45
₦80,302.43
List Price:  ₦112,429.83
You save:  ₦32,127.40
₨14,092.14
List Price:  ₨19,730.13
You save:  ₨5,637.98
฿1,631.54
List Price:  ฿2,284.29
You save:  ฿652.75
₺1,930.15
List Price:  ₺2,702.37
You save:  ₺772.21
B$284.35
List Price:  B$398.12
You save:  B$113.76
R912.87
List Price:  R1,278.09
You save:  R365.22
Лв86.27
List Price:  Лв120.79
You save:  Лв34.51
₩69,134.75
List Price:  ₩96,794.18
You save:  ₩27,659.43
₪180.60
List Price:  ₪252.86
You save:  ₪72.25
₱2,782.09
List Price:  ₱3,895.15
You save:  ₱1,113.05
¥7,151.46
List Price:  ¥10,012.62
You save:  ¥2,861.16
MX$986.62
List Price:  MX$1,381.36
You save:  MX$394.73
QR182.01
List Price:  QR254.83
You save:  QR72.82
P680.79
List Price:  P953.17
You save:  P272.37
KSh6,466.20
List Price:  KSh9,053.20
You save:  KSh2,587
E£2,532.28
List Price:  E£3,545.40
You save:  E£1,013.11
ብር6,728.99
List Price:  ብር9,421.13
You save:  ብር2,692.13
Kz45,590.88
List Price:  Kz63,830.88
You save:  Kz18,240
CLP$46,974.10
List Price:  CLP$65,767.50
You save:  CLP$18,793.40
CN¥364.67
List Price:  CN¥510.57
You save:  CN¥145.90
RD$2,951.01
List Price:  RD$4,131.65
You save:  RD$1,180.64
DA6,620.71
List Price:  DA9,269.53
You save:  DA2,648.81
FJ$112.89
List Price:  FJ$158.06
You save:  FJ$45.16
Q385.11
List Price:  Q539.19
You save:  Q154.07
GY$10,461.12
List Price:  GY$14,646.40
You save:  GY$4,185.28
ISK kr6,476.70
List Price:  ISK kr9,067.90
You save:  ISK kr2,591.20
DH463.01
List Price:  DH648.26
You save:  DH185.24
L854.82
List Price:  L1,196.82
You save:  L341.99
ден2,720.08
List Price:  ден3,808.34
You save:  ден1,088.25
MOP$400.55
List Price:  MOP$560.81
You save:  MOP$160.25
N$933.50
List Price:  N$1,306.98
You save:  N$373.47
C$1,845.09
List Price:  C$2,583.28
You save:  C$738.18
रु6,780.01
List Price:  रु9,492.56
You save:  रु2,712.54
S/183.84
List Price:  S/257.39
You save:  S/73.55
K202.87
List Price:  K284.03
You save:  K81.16
SAR187.50
List Price:  SAR262.52
You save:  SAR75.01
ZK1,390.76
List Price:  ZK1,947.17
You save:  ZK556.41
L223.42
List Price:  L312.80
You save:  L89.38
Kč1,102.17
List Price:  Kč1,543.13
You save:  Kč440.96
Ft17,861.90
List Price:  Ft25,008.10
You save:  Ft7,146.19
SEK kr481.46
List Price:  SEK kr674.08
You save:  SEK kr192.62
ARS$60,088.51
List Price:  ARS$84,128.72
You save:  ARS$24,040.21
Bs346.56
List Price:  Bs485.21
You save:  Bs138.65
COP$212,759.82
List Price:  COP$297,880.78
You save:  COP$85,120.95
₡25,326.52
List Price:  ₡35,459.16
You save:  ₡10,132.63
L1,301.19
List Price:  L1,821.77
You save:  L520.58
₲401,593.41
List Price:  ₲562,262.91
You save:  ₲160,669.49
$U2,096.75
List Price:  $U2,935.62
You save:  $U838.87
zł188.68
List Price:  zł264.17
You save:  zł75.48
Already have an account? Log In

Transcript

The Select tool is useful for modifying and rearranging your data set. It allows you to include exclude, reorder, rename, or resize columns in your data set. Also, if you remember chapter 1.5 date time now, you'll recall that the current date and time is actually stored as text by default, and the Select tool allows us to set it back to a date format. Let's start a new workflow by importing spreadsheet 2.2 into our workflow. We'll go to the Insert tab, drag in our input data tool, and select 2.2 select spreadsheet. Press OK. And again, we have our example HR file here.

We'll go to the preparation tab and drag in a select tool. And in the configuration menu on the left, we have the metadata for our fields and this is why we can play around with it and Maybe rename last name to surname, date of birth to GRB date of joining to join date. Let's move salary to the end of the file. And finally, we can see that ultrix has picked a date of birth and date of joining as date formats. Let's add a browse tool to the end of this by pressing Ctrl Shift B and we'll run our workflow. As you can see, the columns have been renamed here surname to DOB and joined date and salary has been rearranged.

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.