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
Solved! Go to Solution.
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
Thanks for the response exactly what I was looking for!!
Much appreciated
Shane
Thanks Diego! Much appreciated