I have a set of user data that has a column "User Code" that has 1, 2 or 3 values for each user:
| User # | User Code |
| 1 | ABC |
| 1 | DEF |
| 2 | ABC |
| 3 | DEF |
| 3 | GHI |
| 3 | JKL |
The workflow looks at one user's data at a time. For any given row of data, there is one User Code listed. The next row will display the next User Code and so on, repeating for as many rows as the User has:
| User # | User Code |
| 3 | DEF |
| 3 | GHI |
| 3 | JKL |
| 3 | DEF |
| 3 | GHI |
I used CrossTab to break them out so each customer has one column for each of their codes:
| User # | DEF | GHI | JKL |
| 3 | DEF | GHI | JKL |
| 3 | DEF | GHI | JKL |
| 3 | DEF | GHI | JKL |
This is exactly what I want, except for the column headers ("DEF," "GHI," "JKL"). I can use Select to rename them to "Code1," "Code2", and "Code3," but if the next user doesn't have the same codes, they won't be selected to be renamed ("ABC," for example, would not be picked up in the above example).
I suspect the Dynamic Rename tool is the way to handle this, but I can't figure out how. I appreciate any guidance you can share! Thanks.
