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.
I'm struggling with a simple problem that I know will be easy in Alteryx, I just can't figure out how. I'm dealing with some duplicate data, two records per customer. Here is a simplified example of the source:
...which I want to turn into this:
I thought this would be a cross tab but there are too many categories. Each customer has two purchases, and I want to display each purchase side by side. How do I do it? Thanks
Of course! Thank you. I forgot about the text to columns tool.
I also realised it's possible to do this with a dummy field of 1, a running total and a cross tab. This could avoid any issues with text to columns. It's attached, beneath the original version. Thanks for your prompt help!
I was able to resolve this by using the Formula tool to add 3 new fields such as PurchasedCar, PurchasedBoat and PurchasedPlane, and populated the values of the 3 new fields for each row based on the concatenated Purchased value using a string comparison function. Thanks.