ALTERYX EXAM- TOOLS- QUESTIONS
WITH COMPLETE SOLUTIONS
Record ID - Answer-Assigns a unique numeric value to each row of data
Formula - Answer-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 - Answer-Applies the same expression to all selected columns
Text to Columns - Answer-Able to split field by delimiter into a set of columns and then
can rename using the select node
Replace - Answer-Replaces a string that matches the specified regular expression with
another string specified in the Replace option
Parse - Answer-Extracts any group specified and places each in a separate column
Match - Answer-Test if a string matches the specified regular expression
Filter - Answer-Allows you to filter out data you want by choosing specific criteria to filter
the whole data set
Sort - Answer-Allows sorting of data in ascending or descending order (sorts based on
first field)
Sample - Answer-Limit the data to a certain number, percentage, or random set of
records out of the whole data set
Random Sample % - Answer-Generates a random number or percentage of records
passing through the data stream
Unique - Answer-Separate data into two streams based on the fields of the user's
choosing
Inner Join - Answer-Both sides have to match, only those records are returned
Left Unjoin - Answer-Show records (and their attributes) that only exist in the left table
Right Unjoin - Answer-Show records (and attributes) that only exists in the right table
Left Outer Join - Answer-Inner join + left unjoin
Right Outer Join - Answer-Inner join + right union
WITH COMPLETE SOLUTIONS
Record ID - Answer-Assigns a unique numeric value to each row of data
Formula - Answer-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 - Answer-Applies the same expression to all selected columns
Text to Columns - Answer-Able to split field by delimiter into a set of columns and then
can rename using the select node
Replace - Answer-Replaces a string that matches the specified regular expression with
another string specified in the Replace option
Parse - Answer-Extracts any group specified and places each in a separate column
Match - Answer-Test if a string matches the specified regular expression
Filter - Answer-Allows you to filter out data you want by choosing specific criteria to filter
the whole data set
Sort - Answer-Allows sorting of data in ascending or descending order (sorts based on
first field)
Sample - Answer-Limit the data to a certain number, percentage, or random set of
records out of the whole data set
Random Sample % - Answer-Generates a random number or percentage of records
passing through the data stream
Unique - Answer-Separate data into two streams based on the fields of the user's
choosing
Inner Join - Answer-Both sides have to match, only those records are returned
Left Unjoin - Answer-Show records (and their attributes) that only exist in the left table
Right Unjoin - Answer-Show records (and attributes) that only exists in the right table
Left Outer Join - Answer-Inner join + left unjoin
Right Outer Join - Answer-Inner join + right union
