Alteryx-Core Data Preparation Practice Question

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 formula requires an IF statement to handle negative values.

  Why it's wrong here

  The error message specifically references a type mismatch between a string and a numeric requirement. Adding an IF statement would not resolve the underlying data type issue, as the engine would still encounter the string value when evaluating the mathematical expression, causing the same error to persist.

• ✓

  Use the Select tool to change 'Sales' to a numeric type

  Why this is correct

  The Select tool is the standard method for changing field types. By changing 'Sales' to Double or Integer, the Formula tool will recognize the data as numeric. This is the most efficient and readable way to fix type errors in an Alteryx workflow prior to calculation.

• ✗

  The formula needs to be wrapped in a ToNumber() function

  Why it's wrong here

  While ToNumber() inside the Formula tool could convert the string, it is often better practice to cast data types at the schema level using the Select tool. This keeps the Formula tool logic clean and improves performance by ensuring the data is correctly typed upstream of the calculation.

• ✗

  The 'Sales' column has hidden characters that must be trimmed

  Why it's wrong here

  Trimming whitespace only removes leading or trailing spaces; it does not change the data type of the field. If the field is defined as a string, it will remain a string after trimming, and the formula engine will continue to reject the non-numeric data type provided.