When new values are added to the Transpose By field within a Transpose node you must Get Values to add them to the rest of the downstream process of the job. This process is not done automatically. The quickest way to add values from within the column you’ve chosen is to use the Get Values button. You can also add values manually.
When new values are included in the data, you must acknowledge that you want them turned into columns. To add new values within the Transpose Node: select Get Values > Run to Get Values. Then make your selection of values that populate in the Unique Values window by removing those that are unwanted.
Note: Hold down the shift button to select and delete multiple values at once.
You can also use the Add button (blue plus sign) to add a value manually, or to add a value that did not appear when you used the Get Values feature. The Delete button (red X), on the other hand removes values from the list one at a time.