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.

Parse_Problem.yxdb

fmvizcaino

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

2020-09-11 Parse Preparation Problem.yxmd