Alteryx-Core Data Transformation — 15 Questions

Question 1

You need to split a single string column containing delimited values (e.g., 'Apple,Banana,Cherry') into separate rows. Which TWO tools can accomplish this? (Select two)

Accepted Answer

Text to Columns tool. Both the Text to Columns tool and the Regex tool are highly effective for parsing delimited strings. In Alteryx, the Text to Columns tool provides a simple configuration to split strings into rows, while the Regex tool offers more granular control using capture groups. Knowing both methods is essential for handling dirty data where delimiters might be inconsistent or nested within complex string structures.

Answer

Formula tool

Answer

Summarize tool

Answer

Filter tool

Question 2

When cleaning data, which THREE tasks are best handled by the Data Cleansing tool? (Select three)

Accepted Answer

Removing null values. The Data Cleansing tool automates common, repetitive data cleanup tasks that would otherwise require multiple individual tools. By selecting a set of columns, it can handle null replacement, whitespace trimming, and case normalization simultaneously. This tool is highly valued for efficiency in data preparation, ensuring consistency across large datasets and reducing the number of nodes required to sanitize input before analysis begins.

Answer

Joining two datasets

Answer

Changing the data type of a column

Question 3

Refer to the exhibit. You are using the Regex tool to parse phone numbers (XXX-XXX-XXXX). With 'Columns' output mode selected, how many new columns will be generated?

Accepted Answer

Three. The number of columns generated by the Regex tool is determined by the number of capture groups defined in the pattern. Each set of parentheses represents a group. Since this pattern has three groups: (\d{3}), (\d{3}), and (\d{4}), the Regex tool will output three separate columns, each containing the matched text from its respective capture group. Understanding this is vital for parsing structured string data into usable numerical or categorical fields.

Answer

One

Answer

Two

Answer

Four

Question 4

When using the Filter tool, which THREE of the following are valid ways to build a filter expression? (Select three)

Accepted Answer

Using 'Basic' filter mode. The Filter tool provides three distinct modes for expression building: Basic, Custom, and Macro. The 'Basic' mode uses a simple dropdown interface, while 'Custom' allows for complex Alteryx formula syntax, including logical operators (AND/OR) and functions. Mastering these modes allows users to handle everything from simple one-off filtering tasks to dynamic, formula-driven conditions that adapt to changing data requirements in automated production environments.

Answer

Using 'Regex' mode

Answer

Using 'Join' mode

Question 5

You have a column containing currency values formatted as text (e.g., '$1,200.50'). Which series of tools is best to convert this into a numeric double format?

Accepted Answer

Data Cleansing tool then Select tool. To convert currency text to numbers, you must first remove the non-numeric characters ($, comma) and then update the data type. The Data Cleansing tool is excellent for removing punctuation, while the Select tool provides the necessary interface to change the data type to a numeric format. This two-step process ensures the data is clean and correctly typed for mathematical calculations.

Answer

Select tool only

Answer

Formula tool only

Answer

Summarize tool then Sort tool

Question 6

Refer to the exhibit. The Formula tool is failing to perform a calculation because of mixed data types. Which specific action should be taken to fix this error inside the formula expression?

Accepted Answer

Wrap the field in a ToNumber() function within the formula.. When a field contains mixed types, Alteryx cannot perform arithmetic. The error indicates the formula expects a number but receives a string. Using a conditional function like 'IF IsNull([Field]) THEN 0 ELSE ToNumber([Field]) ENDIF' ensures the data is strictly numeric before calculation. This is a common pattern in Alteryx to handle messy inputs without breaking the workflow process.

Answer

Use the Select tool to force the field to a string type.

Answer

Use the Data Cleansing tool to remove all non-numeric characters.

Answer

Apply a Filter tool to remove all null rows.

Question 7

You need to aggregate data to calculate total sales per region, but you also want to keep the original transaction details. Which tool allows you to perform this aggregation and join it back to the original data?

Accepted Answer

Join Tool. The Summarize tool is the engine for aggregation, while the Join tool facilitates merging the aggregated result with the original dataset. By joining the summary back to the source data on the 'Region' field, you can append the total sales value to every individual row, enabling row-level comparisons against the group totals without losing the granular transaction-level details required for detailed analysis.

Answer

Summarize Tool

Answer

Append Fields Tool

Answer

Transpose Tool

Question 8

Which THREE actions are commonly performed using the 'Data Cleansing' tool?

Accepted Answer

Replacing null values with a constant like 0 or blank.. The Data Cleansing tool is a macro that simplifies standard data cleaning tasks. It automates common procedures like replacing nulls with zeros, removing leading/trailing whitespace, and stripping non-alphanumeric characters. Mastering this tool is essential for rapid data preparation, as it prevents the need for manual, repetitive configurations in multiple Formula or Select tools, ensuring consistent quality across the data pipeline.

Answer

Joining two datasets based on a shared key field.

Answer

Converting data types from string to spatial objects.

Question 9

Refer to the exhibit. You are using the Data Cleansing tool, and this warning appears. What is the most likely cause for this behavior?

Accepted Answer

The field contains actual text characters, not just numbers.. The Data Cleansing tool's 'Replace Nulls with 0' feature only applies to numeric fields. If the field is assigned a string data type, the tool cannot perform math or replace nulls with a numeric 0 correctly. It issues a warning because the metadata is inconsistent with the requested operation, forcing you to cast the field to a numeric type first.

Answer

The tool is unable to process large volumes of data.

Answer

The input file is missing a header row.

Answer

The tool is not connected to a valid input stream.

Question 10

You have a dataset where multiple rows represent the same customer, and you need to flatten these into a single row per customer. Which THREE tools can be combined to perform this aggregation and restructuring?

Accepted Answer

Summarize tool. Data flattening often requires aggregating existing row values and then potentially pivoting or reshaping the output. By using a combination of Sort, Summarize, and potentially Transpose or Cross Tab, you can condense granular data into a single summary record. Understanding these combinations is vital for generating reports, building customer 360 views, or preparing data for machine learning models that expect a one-row-per-entity format.

Answer

Filter tool

Answer

Select tool

Question 11

Refer to the exhibit. Why is the output 'Low' instead of 'Null' or an error?

Accepted Answer

The expression evaluator treats NULL as False for the IF condition.. In Alteryx, NULL values are treated as less than any numeric value in a standard logical comparison. When the IF statement evaluates 'NULL > 1000', the comparison returns False. Therefore, the logic proceeds to the ELSE branch. Understanding this behavior is critical for data quality; if you need to specifically identify NULLs, you must explicitly check for them using the IsNull() function before performing numeric comparisons.

Answer

NULL is treated as 0 in numeric comparisons.

Answer

The Formula tool automatically replaces NULL with 0.

Answer

The engine ignores NULL rows during calculation.

Question 12

Which TWO of the following tools allow you to perform data aggregation based on grouped categories?

Accepted Answer

Summarize tool. Aggregation is the cornerstone of data summarization. Both the Summarize tool and the Pivot/Cross Tab functionality allow grouping. The Summarize tool is the classic approach for numerical aggregation, while the Cross Tab tool is used for reshaping. Knowing when to use each is essential for generating concise business reports and preparing datasets for analytical dashboards, as they represent the primary ways to reduce data granularity.

Answer

Transpose tool

Answer

Formula tool

Answer

Select tool

Question 13

Refer to the exhibit. Which tool produced this result, and what was the original format of the data?

Accepted Answer

Transpose tool; wide format.. The Transpose tool is the only tool that takes multiple data columns and converts them into individual rows for each key. The original data had 'Jan', 'Feb', and 'Mar' as separate columns, and the transformation resulted in three rows per ID (one for each month). This transformation is common when moving from a spreadsheet format to a transactional database format suitable for time-series analysis.

Answer

Cross Tab tool; long format.

Answer

Summarize tool; wide format.

Answer

Join tool; wide format.

Question 14

Which TWO of the following tools allow you to change the data type of a field in Alteryx?

Accepted Answer

Select tool. The Select and Auto Field tools are the primary mechanisms for managing data types in Alteryx. The Select tool allows manual specification of field types, while Auto Field dynamically optimizes types based on data content. Understanding these tools is essential for maintaining data integrity and optimizing memory usage, as incorrect data types frequently cause downstream tool errors or precision loss during complex mathematical calculations.

Answer

Filter tool

Answer

Formula tool

Answer

Sort tool

Question 15

Refer to the exhibit. If [Sales] contains a Null value, what will the output be?

Accepted Answer

Low. In Alteryx, a null value in a numeric field is considered 'less than' any numeric comparison in an IF statement. Therefore, the condition [Sales] > 1000 evaluates to False, and the formula defaults to the ELSE branch. This behavior is vital to understand, as failing to explicitly handle nulls often leads to incorrect categorizations, which can silently propagate errors throughout your data analysis without triggering explicit tool-level alerts.

Answer

Null

Answer

High

Answer

Error