Moving the right text to the right cell

[Chalsea]

Hello community,

I'm pretty new to Alteryx and would love some help!

Maybe this is very simple, but somehow i cannot seem to find the solution: how can i move specific text from one column to another column within a workflow if those values are out of order? Also, how can I do it in bulk if there are many of the scenarios like this? 

For example, 

1. I have a column of string that I need to parse out that looks like this

East/Video/YouTube/20%Off/Toy/LA/Yes/NA/Small/Delivery

2. once it's parsed out, see below, however, some of the value is out of order, for example,

a. under Product column "20% Off" should belong to Price column,

b. and under Price column "Toy" should be belong to Product column,

c. under Promotion "LA" should be long to Market column

d. under Market column "Yes" should belong to Promotion column

e. under Size column "NA" is not useful and can be eliminated

f. under Delivery/Pick up column "Small" should be shifted to Size column

h. under Value 1 "Delivery" should be moved to Delivery column

Region	Source	Site	Product	Price	Promotion	Market	Size	Delivery/Pick up	Value 1	Value 2	Value 3
East	Video	YouTube	20% Off	Toy	LA	Yes	NA	Small	Delivery

ideally I need them to be like this.  

Source	Site	Product	Price	Promotion	Market	Size	Delivery/Pick up
Video	YouTube	Toy	20% Off	Yes	LA	Small	Delivery

I've attached the excel file and the workflow. Can someone show me how I should do it in the workflow? 

Here is an illustration of the messy data vs cleaned data. Ideally I would love to move all the color blocks that doesn't match the first row to its according color. 

Before:  

After: 

If anyone can send me into the right direction that would be awesome!

Thanks in advance! 

Chalsea

[Chalsea]

Thanks Simha! I downloaded your workflow and played around with it. Not sure if I'm missing something. Can you walk me through in my attached workflow (see the post) how to reassign those values that should belong to where they should be? For example, current the parsed out data is in this format:

Ideally they should be reorder into this format. 

 

[Chalsea]

Thanks @Yalmar! I updated my post with workflow. As a newbie to Alteryx, can you show me how to use select tool to rearrange those values? Can I use select tool to move specific value of each cell? Thanks!

[fmvizcaino · Accepted solution]

Hi @Chalsea ,

As you have a lot of different formats, the best way to tackle this problem is by dividing your dataset. My approach was mainly analyzing where the 'Off' word was.

Take a look and let me know if this works for you.

BEst,

Fernando Vizcaino

[Chalsea]

Thanks so much @fmvizcaino! It worked. Much appreciated sharing the detailed solutions!