Adding field to the table
You can add or edit the fields for the selected table to upload them to the specified client table.
To add a field:
-
Select Administration > Extract > Data Lake Upload Setup > Table tab.
Note: To add more than a field to the table, you can select the Add Multiple Fields option.
- SelectActions > Add/Edit Fields. The field page is displayed
-
Specify this information in the detail section:
- Field ID
- A unique ID which is sequentially generated by the application for the field.
- Field
- The name of the field.
- Client Field Name
- The name of the field on the client table.Note: By default, the value is same as the field name. However, you can modify it.
- Data Type
- The data type associated with the of the selected field. The value is populated and disabled.
- Timestamp Field
- If this check box is selected, the date and time the field is selected for the upload, is recorded.
-
Click Save.
Note: The application sets the Table status to Inactive when a field is added or deleted.