Alteryx Core Cert Exam Questions and
Answers
what is the symbol for no delimeter - Correct Answers -/0
Data Quality Categories - Correct Answers -NOT OK (RED): values contain leading or
trailing white space
NULL (YELLOW): no values were provided
EMPTY (GRAY): strings with no values
OK (GREEN): values without leading or trailing whitespace, NULL, or empty values
Alteryx Field Type File (.yxft) - Correct Answers -text file that describes the file
configuration of field names and field types. The name, type, size, and order are all
saved in the file, which can then be loaded via the Select tool or any tool with an
embedded select.
"Find" anchor - Correct Answers --where you connect the data that you want to search
-dataset connected to this anchor will be output by the tool
beginning of field - Correct Answers -searches the column for the lookup string at the
very beginning of the cell. does not match if another character is before or within
any part of field - Correct Answers -searches the column for the lookup string anywhere
in the cell. does not match if another character is within.
Find Replace - Correct Answers --Beginning of Field: just the first character
-any part of field: anywhere in the field
-entire field: field only contains this phrase or character
-this tool is case sensitive by default ( can check the box for "case insensitive"
"find value from column" section in the find replace tool - Correct Answers -searches the
corresponding column connected to the REPLACE input anchor
Find/Replace vs Join Tool - Correct Answers --Find/Replace is more flexible. Join too
requires an exact match (case,spelling,punctuation,white space)
-Find/Replace ONLY works with STRING data. Join works with MULTIPLE data types.
Answers
what is the symbol for no delimeter - Correct Answers -/0
Data Quality Categories - Correct Answers -NOT OK (RED): values contain leading or
trailing white space
NULL (YELLOW): no values were provided
EMPTY (GRAY): strings with no values
OK (GREEN): values without leading or trailing whitespace, NULL, or empty values
Alteryx Field Type File (.yxft) - Correct Answers -text file that describes the file
configuration of field names and field types. The name, type, size, and order are all
saved in the file, which can then be loaded via the Select tool or any tool with an
embedded select.
"Find" anchor - Correct Answers --where you connect the data that you want to search
-dataset connected to this anchor will be output by the tool
beginning of field - Correct Answers -searches the column for the lookup string at the
very beginning of the cell. does not match if another character is before or within
any part of field - Correct Answers -searches the column for the lookup string anywhere
in the cell. does not match if another character is within.
Find Replace - Correct Answers --Beginning of Field: just the first character
-any part of field: anywhere in the field
-entire field: field only contains this phrase or character
-this tool is case sensitive by default ( can check the box for "case insensitive"
"find value from column" section in the find replace tool - Correct Answers -searches the
corresponding column connected to the REPLACE input anchor
Find/Replace vs Join Tool - Correct Answers --Find/Replace is more flexible. Join too
requires an exact match (case,spelling,punctuation,white space)
-Find/Replace ONLY works with STRING data. Join works with MULTIPLE data types.
