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 

[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

[DiegoParker · Accepted solution]

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

[DiegoParker · Accepted solution]

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

[ShaneB19]

Thanks for the response exactly what I was looking for!! 

Much appreciated

Shane

[ShaneB19]

Thanks Diego! Much appreciated