Convert Values to Columns

For each row, if the value represented by the column is present in the original data, one value is added (For example, Yes). If it's missing, another value is inserted (For example, No).

Source:

The following example contains transactional information about products sold in individual stores. In the transformation, the values in the Store_Nbr column are converted to columns.

Transformation:

In the following, the values in the Store_Nbr column have been converted to individual columns:

In the above:

• Fill when present identifies the string literal value to insert if the row contains the column's value (Yes).
• Fill when missing identifies the string literal value to insert if the row does not contain the column's value (empty).

• Max number of columns to create places a limit on the total number of columns that the application is permitted to create. In this case, the limit is set to 250 since the known number of stores is 250.

  Tip: It's a good habit to set limits on the maximum number of columns to create. Data can become sparse or unwieldy if limits are not considered.

Results: