Cloud Integration Hub

Back Next

Add Table from Flat File properties

Add a topic table from a flat file that contains the structure of a table in the data domain that the topic represents.

The

Add Table from Flat File

page includes the following properties:

File: Name of the file that contains the structure of the data domain that the topic represents.
Drop a file into the
File
field or click
Choose File
to browse to and choose the sample file on which to base the table structure.
Table Name: Name of the topic table. The name must begin with an alphabetic character or underscore and can contain only ASCII alphanumeric characters or underscores. The name must be unique in the
Cloud Integration Hub
repository.
Import Column Names: Optional. Select this option to use the column names in the file as the default column headers in the table. Enter the number of the lines that serves as the file's header line in the
From Line
field.
Code page: Character encoding used in the file.
Default text length: Optional. Length of the text fields in the table.
Delimiter: Delimiter used in the file to separate between columns. Select a predefined delimiter or select
Custom
to define a custom delimiter.
Text qualifier: Optional. Symbols used in the file to enclose a string.
Load File: Loads the selected file and shows a preview of the file.
Preview: Shows the columns that will be added to the table after you load the file.