Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Interactive Lessons

Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.

Also available in | Français | Português | Español | 日本語

Separating Data into Columns and Rows

Back to Lessons Feedback
ChristineB
Alteryx Alumni (Retired)
Created

 

Lesson Objective: Learn how to split delimited data into columns and rows using the Text to Columns tool in the Designer. 

Estimated Time: ~5 Minutes

Description:  

  • Understand how delimiters indicate distinct data values
  • Separate data values into columns based on a delimiter
  • Split delimited values into rows
  • Test your knowledge with a quiz

Recommended Follow-Up: Sorting Data, VLookUps with Designer

This lesson is also available in: French, Spanish, Portuguese, and Japanese