Parse/Preparation Problem

[Nicholas_Norton]

Hi there! I'm pretty new to Alteryx and I'm trying to solve this parsing problem. I have a number of stores, each with a supply of different categories of food. For example, Store 1 has 165 bags of wheat, and 77 bags of rice, and so on and so forth. The problem is that each category is unordered from one store to the next and compiled into a single line of text for each amount. How would I assign the right Category to the right Amount? Thank you! I have the yxdb file attached.

[fmvizcaino · Accepted solution]

Hi @Nicholas_Norton ,

Here it is.

First I'm using the text to columns to transpose the category into rows and then I use positional join.

Best,

Fernando Vizcaino

[Nicholas_Norton]

Thank you! This solution is way easier than what I was trying to do!