When you want to apply a small tweak to the document, it should not require much time to Systematize columns text. This type of simple activity does not have to require extra education or running through manuals to learn it. Using the proper document modifying tool, you will not take more time than is necessary for such a quick change. Use DocHub to simplify your modifying process whether you are an experienced user or if it’s your first time using a web-based editor service. This instrument will require minutes or so to learn to Systematize columns text. The only thing needed to get more productive with editing is actually a DocHub account.
A plain document editor like DocHub can help you optimize the time you need to dedicate to document modifying regardless of your prior knowledge about this kind of instruments. Create an account now and boost your efficiency instantly with DocHub!
welcome to the Alteryx basics video series in this first video Ill show you how to separate structured data from a single field into many fields using the text to columns tool lets take a look at the data well be working with our data set has a field item that contains the item number the color the brand to prepare this data for analytics we need to parse the data into separate fields lets connect to our data source drag the input data tool from favorites onto the canvas go to Program Files then the ultrix folder then samples sample data look for a file called clothing underscore search CSV highlight it and click open from the parse palette drag the text to columns tool onto the canvas and drop it after your input data tool the text to columns tool allows us to specify a delimiter and split the data from a single field into a known number of columns well use the space character for the delimiter were assuming that in our data set every record will have an item field that contain