| Excerpt |
|---|
This example illustrates you to use the flatten and unnest transforms. |
Source:
You have the following data on student test scores. Scores on individual scores are stored in the Scores array, and you need to be able to track each test on a uniquely identifiable row. This example has two goals:
...
| TestId | LastName | FirstName | TestNum | TestScore | studentId | avg_TestScore |
|---|---|---|---|---|---|---|
| TestId0021 | Adams | Allen | 0 | 81 | Adams-Allen | 82.5 |
| TestId0022 | Adams | Allen | 1 | 87 | Adams-Allen | 82.5 |
| TestId0023 | Adams | Allen | 2 | 83 | Adams-Allen | 82.5 |
| TestId0024 | Adams | Allen | 3 | 79 | Adams-Allen | 82.5 |
| TestId0031 | Adams | Bonnie | 0 | 98 | Adams-Bonnie | 92.25 |
| TestId0032 | Adams | Bonnie | 1 | 94 | Adams-Bonnie | 92.25 |
| TestId0033 | Adams | Bonnie | 2 | 92 | Adams-Bonnie | 92.25 |
| TestId0034 | Adams | Bonnie | 3 | 85 | Adams-Bonnie | 92.25 |
| TestId0041 | Cannon | Chris | 0 | 88 | Cannon-Chris | 83 |
| TestId0042 | Cannon | Chris | 1 | 81 | Cannon-Chris | 83 |
| TestId0043 | Cannon | Chris | 2 | 85 | Cannon-Chris | 83 |
| TestId0044 | Cannon | Chris | 3 | 78 | Cannon-Chris | 83 |
| D s also | ||
|---|---|---|
|
