Alteryx-Core Data Manipulation Practice Question
Exhibit
Formula: IF [Status] = 'Active' THEN [Amount] * 0.1 ELSE 0 ENDIF
Refer to the exhibit. The workflow runs without error, but the result column is entirely populated with 0s despite having 'Active' statuses in the input. What is the most likely reason?
⚠ Common exam trap
Candidates frequently assume the workflow logic is flawed when zero results appear, failing to recognize that hidden trailing spaces in string data cause exact equality filters to silently fail.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The [Status] column contains hidden trailing whitespace.
The issue likely stems from hidden whitespace or case-sensitive mismatches. If 'Active' in the data actually reads 'Active ' (with a trailing space), the equality check will fail. This scenario highlights the importance of data cleaning tools like the Data Cleansing tool, which can remove whitespace before evaluation. Validating string inputs is a critical step in Alteryx manipulation to prevent silent logical failures that produce inaccurate analytical results without alerting the user.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The [Amount] column is set as a String data type.
Why it's wrong here
If the Amount column were a string, the multiplication operation would likely trigger a conversion error or return a null value rather than zero. Alteryx generally attempts to implicitly convert numeric strings to doubles, so this is rarely the cause of a silent zero result.
- ✓
The [Status] column contains hidden trailing whitespace.
Why this is correct
Equality operators in Alteryx are literal. If the cell value is 'Active ' (with a space), it does not equal 'Active'. Using the Trim() function or a Data Cleansing tool to remove whitespace is necessary to ensure that string comparisons correctly identify matches.
- ✗
The formula requires an ELSEIF statement instead of an ELSE.
Why it's wrong here
The syntax is valid as written. Adding an ELSEIF would only matter if there were additional logic conditions to evaluate. The structure of the IF-THEN-ELSE statement is correct for the logic provided, and would not cause the existing 'Active' values to return zero.
- ✗
The [Amount] column contains NULL values.
Why it's wrong here
If the Amount column contained nulls, the math result would be null, not zero. Alteryx propagates nulls through mathematical operations unless specifically handled with an IsNull() check or a Null() replacement strategy. Zeroes suggest the logic path for 'Active' was never triggered.
About these practice questions
Courseiva writes every Alteryx-Core question from scratch — 142 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Alteryx exam blueprint
This Alteryx-Core practice question is part of Courseiva's free Alteryx certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Alteryx-Core exam.