Hi friends,
I have to do a basic task on Alteryx but I'm having doubts about it. I have a file that looks like this:
| Student ID | Score |
| SSS1 | 12 |
| SSS1 | 14 |
| SSS1 | 16 |
| SSS1 | 13 |
| SSS2 | 14 |
| SSS2 | 14 |
| SSS3 | 15 |
| SSS3 | 20 |
| SSS3 | 11 |
My intetion is to split this table into different outputs (without exporting) everytime the "student ID" changes. So for every "student ID", I want to create a table. The output should look like this:
Table 1
| Student ID | Score |
| SSS1 | 12 |
| SSS1 | 14 |
| SSS1 | 16 |
| SSS1 | 13 |
Table 2
| Student ID | Score |
| SSS2 | 14 |
| SSS2 | 14 |
Table 3
| Student ID | Score |
| SSS3 | 15 |
| SSS3 | 20 |
| SSS3 | 11 |
Etc.
Unfortunately I can't use the filter tool because I never know exactly which ID's I have, nor how many. Does anybody know how to? Thank you very much.
