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
Solved! Go to Solution.
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.
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
Thanks so much @fmvizcaino! It worked. Much appreciated sharing the detailed solutions!