- 2 Minutes to read
- Print
- DarkLight
Add New Column (window)
- 2 Minutes to read
- Print
- DarkLight
Navigation Path
In the Main Navigation, click Administration > Attributes.
Click Related Data.
In the Actions column, click > Show Structure or the symbol.
Click Add New Column.
Purpose
The Add New Column window allows you to add new columns to the table of a related data set. Each row of a related data set is one data set. Each column is individual data that belongs to the data set.
For example, when you import a product catalog, the data set (the row) consists of various columns. These columns can be the product ID, product description, the price, and the customer review of the product.
Hint:
You do not create the key column of your structure. The key column identifies the data set. A key column is available automatically and you can use this key without further configuration. In a CSV file, the key column is always the first column. In an XML file, the key column is identified with the tag <row key>.
Related Topics
Information
Setting | Description |
---|---|
Column Name | Defines the name of the column. The name must correspond with the name of the column in the imported data file. Since a special language is used for these functions, the name of the related data set can contain only letters, numbers, and hyphens. Spaces or special characters generate an error. |
Make column unique for Related Data Set | If your system offers this option, you can check this box to define one column on a non-unique data set as "unique". For example, this value can be generated from the user email and orderID. The combination of the key value and the value in this column can occur only once in the data set. The uniqueness of this column is verified during import. |
Data Type | Determines the type of data that is stored in the column. Select the corresponding data type from the drop-down list.
|
Default Value | Sets a value that is entered when no other value is imported into the column. You can leave this field empty or select (None) for Boolean data types. |