Courseiva

Alteryx-Core · topic practice

Data Transformation practice questions

Data Transformation covers reshaping, aggregating, and calculating data in Alteryx Designer workflows. Questions present tool configurations or error exhibits and ask which tool or operation fits: Formula versus Multi-Row Formula, Summarize aggregations, joins, and mapping-based replacements. You must recognize each tool's row-level or grouped behavior and why configuration errors occur.

Courseiva uses original exam-style practice questions designed for learning and revision. The goal is to understand the concepts, recognise exam patterns, and improve through explanations — not memorise copied exam dumps.

Editorial oversight:Johnson Ajibi· MSc IT Security, IEEE Senior Member
20 questionsDomain: Data Transformation

What the exam tests

What to know about Data Transformation

Know when to use Formula versus Multi-Row Formula versus Summarize, and how to replace values from a mapping table. The most important thing is matching each tool to its row-level or grouped behavior and fixing expression errors by checking field names and data types.

Selecting Formula, Multi-Row Formula, or Multi-Field Formula for row-level and cross-row calculations

Using the Summarize tool for Group By, Count, Sum, Average, Min, and Max aggregations

Joining or replacing values with a mapping table via Join, Find Replace, or Replace tools

Configuring data types, field selection, and expression syntax to resolve Formula tool errors

Watch out for

Common Data Transformation exam traps

  • ▸Using the standard Formula tool to reference other rows; it processes one row at a time, so prior or subsequent row access requires Multi-Row Formula.
  • ▸Expecting Summarize to output every original field; it returns only Group By fields and chosen aggregation outputs unless joined back.
  • ▸Mismatching data types or field names in expressions, causing Formula errors instead of converting or selecting the correct field.

Practice set

Data Transformation questions

20 questions · select your answer, then reveal the explanation

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)

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

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?

Exhibit

{
  "action": "Parse",
  "regex_pattern": "(\d{3})-(\d{3})-(\d{4})",
  "output_mode": "Columns"
}

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

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?

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?

Exhibit

JSON Policy Output: {'error': 'Type Mismatch', 'context': 'Formula tool encountered string in numeric field', 'action': 'Replace nulls with 0'}

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?

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

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

Exhibit

Error Log: 'Warning: Tool 5: Field 'Sales' is not numeric; replaced with 0'

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?

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

Exhibit

Formula: IF [Sales] > 1000 THEN 'High' ELSE 'Low' ENDIF
Input Row: Sales = NULL
Output Row: 'Low'

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

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

Exhibit

Configuration: 
- Key Columns: ID
- Data Columns: Jan, Feb, Mar
- Result: 3 rows for each ID.

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

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

Exhibit

Formula: IF [Sales] > 1000 THEN 'High' ELSE 'Low' ENDIF 
Output Column: [Category] (String 10)
Data Type: String

When using the Cross Tab tool, what happens to data that does not have a corresponding value in the 'Group By' columns?

You have a dataset with 50 columns and need to pivot the data from a wide format to a long format. Which tool should you use to convert column headers into row values while keeping key identifiers intact?

Refer to the exhibit. You are using a Formula tool to calculate a new column based on 'Total Sales'. Why is the tool throwing this error?

Exhibit

Error: Formula (10): Parse Error at char 12: 'Field1' is not a valid field name. Ensure column names contain no spaces or special characters if referencing directly.

Which tool would you select to sort your data based on multiple columns in a specific hierarchy, such as sorting by 'Region' then 'Date'?

Which tool configuration is most appropriate if you need to calculate a running total of sales while maintaining the original row structure?

Free account

Track your progress over time

Create a free account to save your results and see which topics improve across sessions.

Focused Data Transformation sessions

Start a Data Transformation only practice session

Every question in these sessions is drawn from the Data Transformation domain — nothing else.

Related practice questions

Related Alteryx-Core topic practice pages

Move into related areas when this topic feels solid.

Frequently asked questions

What does the Alteryx-Core exam test about Data Transformation?
Know when to use Formula versus Multi-Row Formula versus Summarize, and how to replace values from a mapping table. The most important thing is matching each tool to its row-level or grouped behavior and fixing expression errors by checking field names and data types.
How should I use these practice questions?
Select your answer before revealing the explanation. Then read why each option is right or wrong — this active recall approach builds retention far faster than re-reading notes.
Can I practise just Data Transformation questions in a focused session?
Yes — the session launcher on this page draws every question from the Data Transformation domain. Use a 10-question session first to gauge your baseline, then move to 20 or 30 once the weak spots are clear.
Where can I practise other Alteryx-Core topics?
Use the topic links above to move to related areas, or go back to the Alteryx-Core question bank to see all topics.
Are these real exam questions or dumps?
These are original practice questions written to test the same concepts the Alteryx-Core exam covers. They are not copied from any real exam or dump site.