1.2 Text Input

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
€43.38
List Price:  €60.73
You save:  €17.35
£37.33
List Price:  £52.26
You save:  £14.93
CA$69.03
List Price:  CA$96.65
You save:  CA$27.62
A$77.81
List Price:  A$108.94
You save:  A$31.13
S$65.19
List Price:  S$91.27
You save:  S$26.08
HK$387.96
List Price:  HK$543.17
You save:  HK$155.21
CHF 40.35
List Price:  CHF 56.49
You save:  CHF 16.14
NOK kr520.62
List Price:  NOK kr728.92
You save:  NOK kr208.29
DKK kr323.89
List Price:  DKK kr453.48
You save:  DKK kr129.58
NZ$83.20
List Price:  NZ$116.49
You save:  NZ$33.29
د.إ183.61
List Price:  د.إ257.07
You save:  د.إ73.46
৳6,070.98
List Price:  ৳8,499.86
You save:  ৳2,428.88
₹4,256.13
List Price:  ₹5,958.92
You save:  ₹1,702.79
RM218.45
List Price:  RM305.85
You save:  RM87.40
₦80,210.95
List Price:  ₦112,301.75
You save:  ₦32,090.80
₨14,070.31
List Price:  ₨19,699.56
You save:  ₨5,629.25
฿1,654.01
List Price:  ฿2,315.75
You save:  ฿661.74
₺1,909.70
List Price:  ₺2,673.74
You save:  ₺764.03
B$296.54
List Price:  B$415.18
You save:  B$118.64
R934.08
List Price:  R1,307.79
You save:  R373.71
Лв86.05
List Price:  Лв120.48
You save:  Лв34.42
₩70,945.56
List Price:  ₩99,329.46
You save:  ₩28,383.90
₪184.42
List Price:  ₪258.20
You save:  ₪73.78
₱2,827.90
List Price:  ₱3,959.29
You save:  ₱1,131.39
¥7,047.94
List Price:  ¥9,867.68
You save:  ¥2,819.74
MX$982.64
List Price:  MX$1,375.77
You save:  MX$393.13
QR182.12
List Price:  QR254.99
You save:  QR72.86
P688.61
List Price:  P964.11
You save:  P275.50
KSh6,480.12
List Price:  KSh9,072.69
You save:  KSh2,592.56
E£2,522.08
List Price:  E£3,531.11
You save:  E£1,009.03
ብር6,660.99
List Price:  ብር9,325.92
You save:  ብር2,664.93
Kz45,590.88
List Price:  Kz63,830.88
You save:  Kz18,240
CLP$48,373.32
List Price:  CLP$67,726.52
You save:  CLP$19,353.20
CN¥364.22
List Price:  CN¥509.94
You save:  CN¥145.72
RD$3,013.39
List Price:  RD$4,218.99
You save:  RD$1,205.60
DA6,631.10
List Price:  DA9,284.08
You save:  DA2,652.97
FJ$114.26
List Price:  FJ$159.98
You save:  FJ$45.71
Q384.99
List Price:  Q539.02
You save:  Q154.03
GY$10,470.55
List Price:  GY$14,659.61
You save:  GY$4,189.06
ISK kr6,294.74
List Price:  ISK kr8,813.14
You save:  ISK kr2,518.40
DH462.07
List Price:  DH646.94
You save:  DH184.86
L864.80
List Price:  L1,210.80
You save:  L345.99
ден2,682.60
List Price:  ден3,755.86
You save:  ден1,073.25
MOP$399.59
List Price:  MOP$559.47
You save:  MOP$159.87
N$934.21
List Price:  N$1,307.97
You save:  N$373.76
C$1,838.39
List Price:  C$2,573.90
You save:  C$735.50
रु6,812.26
List Price:  रु9,537.71
You save:  रु2,725.44
S/187.05
List Price:  S/261.88
You save:  S/74.83
K206.60
List Price:  K289.26
You save:  K82.66
SAR187.57
List Price:  SAR262.61
You save:  SAR75.04
ZK1,425.02
List Price:  ZK1,995.15
You save:  ZK570.12
L215.78
List Price:  L302.11
You save:  L86.33
Kč1,086.83
List Price:  Kč1,521.65
You save:  Kč434.82
Ft17,667.57
List Price:  Ft24,736.02
You save:  Ft7,068.44
SEK kr475.57
List Price:  SEK kr665.84
You save:  SEK kr190.26
ARS$56,135.49
List Price:  ARS$78,594.19
You save:  ARS$22,458.69
Bs345.83
List Price:  Bs484.19
You save:  Bs138.35
COP$212,266.94
List Price:  COP$297,190.71
You save:  COP$84,923.76
₡25,111.52
List Price:  ₡35,158.13
You save:  ₡10,046.61
L1,293.31
List Price:  L1,810.73
You save:  L517.42
₲399,820.51
List Price:  ₲559,780.71
You save:  ₲159,960.20
$U2,116.99
List Price:  $U2,963.96
You save:  $U846.96
zł185.54
List Price:  zł259.77
You save:  zł74.23
Already have an account? Log In

Transcript

The text input tool lets you manually insert text into a table to create small data sets for input. This is most useful for creating lookup tables. And if you want to share your workflow with others without having to provide a separate input data file. Let's start by going to the inherent pain and dragging in the text input tool into our workflow. In the configuration menu on the left, we have the option of importing a file which is similar to our input data tool, or we can manually type in text here. Please note, the import option only imports the first 1000 rows of your data set.

Let's try manually typing in data and copying and pasting data from a worksheet. So if we use the manual text input here, we can type in some column names and some records. And let's delete all of them. And let's try copying and pasting from a worksheet. Select everything here, copy. And this interface here can be a bit finicky so I suggest clicking on any of these cells and shift tabbing until you get this thick border around the first cell.

Once you've done that, press paste and everything will be nicely pasted in. Press the run workflow button or Ctrl r on the keyboard and we have manually inserted data into our workflow.

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.