In/Out & Parse
View results
What is Browse?
Get rid of columns
What is Select?
Combine lists by adding rows
What is Union?
Row to column
What is Transpose?
Work with dates
What is DateTime?
Bring data into your workflow
Get rid of punctuation or whitespace
What is Data Cleansing?
Append or replace data using data from another data stream
What is Find and Replace?
Returns record count
What is Count Records?
Identify records with a unique ID
What is Record ID?
Writes the results of a workflow to a supported file type or data source
What is Output Data?
Get rid of empty values (need 2 answers)
1. What is Formula?
2. What is Filter?
Combine two or more inputs
What is Join Multiple?
Rank or group data
Perform a calculation (need 2 answers)
1. What is Summarize?
2. What is Formula?
Split one cell into multiple cells
What is Text to Column?
Get rid of rows (need 3 answers)
1. What is Formula?
2. What is Filter?
3. What is Sample?
Group information (need 2 answers)
1. What is Union?
2. What is Find & Replace?
Column to row
What is Cross Tab?
Replace a value (need 2 answers)
1. What is Find & Replace?
2. What is Formula?
Parse, match, or replace data
What is RegEx?
Change a datatype (need 3 answers)
1. What is Select?
2. What is Formula?
3. What is Autofield?
Combine lists by adding columns (need 3 answers)
1. What is Join?
2. What is Find & Replace?
3. What is Append Fields?
Calculates cumulative sum
What is Running Total?
Find a value (unique, min, max)
1. What is Summarize?
2. What is Unique?
3. What is Find & Replace?