Hello,
I run an Excel-based workflow each week. The source data is from a third party vendor, and I have no ability to change the schema.
There is a field "Distribution Platforms." The field contains various "Platform" string values separated by a vertical bar. The number of Platforms may differ from record to record and week to week.
My client would like the output to be adjusted so that my company's platform, "Platform 3," is always listed first. Is there a way to "cut and paste" this part of the string to always appear in the beginning? In cases where "Platform 3" does not exist, the string can be left "as is."
Is there a way to achieve this in Alteryx? Thanks for any guidance you can offer, example below and attached.
Thanks, srt
| Field: Distribution Platforms | |
| Existing Format | Desired Format |
| Platform 1 | Platform 2 | Platform 3 | Platform 4 | Platform 3 | Platform 1 | Platform 2 | Platform 4 |
| Platform 1 | Platform 3 | Platform 3 | Platform 1 |
| Platform 1 | Platform 2 | Platform 3 | Platform 4 | Platform 5 | Platform 6 | Platform 7 | Platform 3 | Platform 1 | Platform 2 | Platform 4 | Platform 5 | Platform 6 | Platform 7 |
| Platform 2 | Platform 3 | Platform 4 | Platform 5 | Platform 3 | Platform 2 | Platform 4 | Platform 5 |
| Platform 3 | Platform 3 |
| Platform 2 | Platform 2 |
