This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Ok this one is a bit tricky for me so appreciate any help in advanced. I am working with a data set that unfortunately isn't very user friendly. It essentially has multiple lines in each cell (though not all). I am trying to split them but only when there are multiple lines. Additionally, I want to text to columns so that the number and state are in seperate columns. I realize this is multiple tools / steps but have tried so many different ways and couldn't get it to work I thought I would provide the starting point and desired result.
This workflow was created by a more recent version of Alteryx, and may contain tools or functionality not present in this version. Alteryx does not support using an earlier version of Alteryx to open a workflow created with a newer version. For best results, download the latest version of Alteryx.
Here is something that should work for you, even as you add more columns to your data. It's dynamic because it parses into rows, then filters on what are numbers and what aren't, rebuilds the table, and joins back into position.