Add a Column

You can add a column to a worksheet when data remediation is enabled.

Data remediation is enabled when your worksheet has a primary key, which occurs only in the following situations:

  • Your worksheet was created by uploading a file. The application generates a primary key in this situation.

  • Your worksheet was created by importing data from a local HANA table or from a remote data source that contains primary keys.

You might want to add a column for situations such as the following:

  • To add a Data_Source column to indicate where the data came from, and to specify as the Source Column in the Priority of sources survival rule when removing duplicate records

  • To add a datetime column to specify in the Most Recent or the Oldest survival rule when removing duplicate records

To add a column to a worksheet:

  1. Navigate to the worksheet where you want to add a column.
  2. (Optional) If you want to add a column immediately to the right of a specific column, select that column heading. Otherwise, the new column will be added to the beginning of the worksheet.
  3. Ensure the Actions panel appears on the right, and click Add a Column.
  4. Specify a unique name for the column.
  5. (Optional) If you do not want the default Text column type, you can select one of the following column data types:
    • Number
    • Date
    • Date and Time
    • Time
    Note
    If you select the Number column type, it is added as a decimal number. You can convert it to an integer number later, if needed.
  6. (Optional) If you want a default value to be automatically filled into every row when this column is added. specify a default value.
    Note
    If you do not specify a default value, the column is filled with a NULL value in every row.
  7. Click Add.
The new column appears at one of the following locations.

  • At the beginning of the worksheet if you did not select a column

  • Immediately to the right of the column you selected on the worksheet before you clicked Add a Column.

You can change its location by dragging the column heading to the position you want.

Editor's note: Do you want to give any instructions for (or a cross-ref w/ info about) converting the Number column type to an integer number like you mentioned in the Note in step 5?