Alteryx Exam- Tools Questions and
Answers (100% Pass)
Record ID
✓ Assigns a unique numeric value to each row of data
Formula
✓ Create new data fields based on expression or by assigning a data
relationship, or to update an existing field, can also reorder fields and
change field types
Multi-Field Formula
✓ Applies the same expression to all selected columns
Text to Columns
✓ Able to split field by delimiter into a set of columns and then can
rename using the select node
Replace
Master01 | September, 2024/2025 | Latest update
, 1 | P a g e | © copyright 2024/2025 | Grade A+
✓ Replaces a string that matches the specified regular expression with
another string specified in the Replace option
Parse
✓ Extracts any group specified and places each in a separate column
Match
✓ Test if a string matches the specified regular expression
Filter
✓ Allows you to filter out data you want by choosing specific criteria to
filter the whole data set
Sort
✓ Allows sorting of data in ascending or descending order (sorts based
on first field)
Sample
✓ Limit the data to a certain number, percentage, or random set of
records out of the whole data set
Master01 | September, 2024/2025 | Latest update