I85PREP
⌘ K
Alteryx Designer Expert study materials
Alteryx Designer Expert study resources

Alteryx Designer Expert: Parsing, Transforming, and Formula Tools

Alteryx Designer Expert · Work through your exam, one topic at a time.

All guide sections

Parsing, Transforming, and Formula Tools

What to know

This domain covers reshaping rows and columns and computing new values. Master the Transpose (wide to long: key columns stay, data columns pivot into name/value pairs) and Cross Tab (long to wide: group fields, header field, value field, aggregation method). Know Text to Columns for delimiter-based splitting and the parsing tools (RegEx, DateTime parse). Formula mastery is essential: IF/THEN/ELSEIF/ENDIF, IIF, Switch, ToNumber/ToString/ToDate, DateTimeFormat/DateTimeParse, string functions (Trim, Left, Right, Substring, Contains, FindString, Replace), and null handling (IsNull, IsEmpty).

Traps

  • Transpose/Cross Tab direction: Questions often describe a shape and ask which tool; remember Transpose = fewer columns, more rows; Cross Tab = the reverse.
  • Aggregation in Cross Tab: Without choosing an aggregation (e.g., Sum, First), duplicates cause errors or unexpected rollups.
  • Formula syntax: Alteryx uses = for equality inside expressions and ENDIF; missing ENDIF or using == is a common distractor.
  • Date formats: DateTimeParse needs a format string matching the input exactly (e.g., %m/%d/%Y); mismatches yield nulls.
  • Type of formula output: String concatenation with + fails; use + only for numbers, and ToString() for text joins.

Rule of thumb

Sketch the target shape first: count columns and rows before and after. If columns shrink, think Cross Tab or Summarize; if columns grow, think Transpose or Text to Columns.

Worked example

A table has one row per customer with month columns Jan–Dec. To chart monthly totals, Transpose the month columns (key = Customer), then Summarize Sum on Value grouped by Name (the month).