My data is formatted in a weird way that’s hard to interpret. I’d like to put the “Trainee” on every single row, but this data only exists on one row. An example of my data is below, and below that is how I would like it to appear.
The only way I can think of doing this is by using the first letter of the first name and the full last name, but if there’s another way to pull directly from the Trainee column that would be better.
Either way, I’m fairly new to Knime and not sure how to do this transformation just yet. Any help at all would be greatly appreciated.
[TRAINEE] [LAST NAME] [FIRST NAME] [CLASS][STATUS]
GWASHINGTON | null | null | null | null |
null | Washington | George | Class 1 | IN PROCESS
null | Washington | George | Class 2 | IN PROCESS
null | Washington | George | Class 3 | IN PROCESS
null | Washington | George | Class 4 | IN PROCESS
KWEST | null | null | null | null |
null | West | Kanye | Class 1 | IN PROCESS
null | West | Kanye | Class 2 | IN PROCESS
null | West | Kanye | Class 3 | IN PROCESS
null | West | Kanye | Class 4 | IN PROCESS
GWASHINGTON | Washington | George | Class 1 | IN PROCESS
GWASHINGTON | Washington | George | Class 2 | IN PROCESS
GWASHINGTON | Washington | George | Class 3 | IN PROCESS
GWASHINGTON | Washington | George | Class 4 | IN PROCESS
KWEST | West | Kanye | Class 1 | IN PROCESS
KWEST | West | Kanye | Class 2 | IN PROCESS
KWEST | West | Kanye | Class 3 | IN PROCESS
KWEST | West | Kanye | Class 4 | IN PROCESS