Reference · Visual workspace
Turn blank text into missing in Visual workspace
Convert empty text into a missing value so blanks and missing values are handled by one rule.
When to use it
After trimming, when the rules say an empty result means nothing was recorded.
How
Add step → Text → Blank to missing.
Blank customer_key → missing
- Run it after Trim, or a value of spaces stays non-empty.
Pitfalls
- Running it before trimming.
- Treating zero as blank.
Lesson: Missing is not empty (and neither is zero)
Practise it: Join orders to customers without matching blanks