Summarize String Data

ShaneB19

Hi All,

New to Alteryx so just experimenting at the minute.

I want to know if there is a way in which I can summarize string data. Here is an example:-

Brentford 12 20 W D W L W W D L W W
Nott'm Forest 7 20 L W W W D W D W L

So i want to do is Brentford W = 6 D = 2 L = 2 And then maybe W as a percentage.

Not sure if this is possible just playing around with ideas at this stage.

Any help is much appreciated!! Thanks

Workflow

Accepted answers

DiegoParker

Hi Shane,

You will have to do a bit of prep here. Please find my approach attached.

Hope this helps If does, can I ask you to mark it as the solution? this will help other users to find it and will allow us to close the thread. Many thanks!

Best,
Diego

Forum Example.yxzp

DiegoParker

Here is an alternative approach which will account for unlimited matches by using the text to columns splitting to rows instead of columns.

It also uses less tools.

Best,

Diego

Forum Example2.yxzp

All comments

afv2688

Hello @ShaneB19,

Are you looking for something like this?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

percentage_letters.yxmd

DiegoParker

Hi Shane,

You will have to do a bit of prep here. Please find my approach attached.

Hope this helps If does, can I ask you to mark it as the solution? this will help other users to find it and will allow us to close the thread. Many thanks!