Forum Discussion
BassG
Helper I
Helper IAnalyse & slice data by delimiter, but not split rows.
Hi all, I've got an issue that I can't seem to work out & looking for help on what the best solution would be. My data looks a little like this... Studen t ID SIMD Sport 1 Sport 2...
SamWiseOwl
Super User
Super UserHi BassG
I am not fully understanding the goal.
Using SIMD 3 what is your assumption?
Mine would be:
All Sports selected: 2 / 3 = 66%
Judo: 1/3 = 33%
Football: 2/3 = 66%
| 4123 | 3 | Shinty | Rounders | Football | Judo | Shinty,Rounders,Football,Judo | 1 | 1 | |
| 4321 | 3 | Football | Football | 1 |
1 |
||||
| 1323 | 3 | 0 |
1 |
SamWiseOwlSuper User
Super User