Connecting an input table to multiple types of data sources can be done by using connection strings. Uploading a file automatically creates a connection string table.
Follow these steps to view the connection string.
Go to the Data tab of your developer environment.
Double click on the table for which you want to view the connection string.
This string denotes that a file is loaded, where it is located, and how this file is parsed. This string is automatically generated when using the Upload a file… option.
Below is a description of the parameters of the connection string.
Defines what type of data connection is created. In this case,
Enables you to disable a connection string. By default, this setting is set to
Denotes the relative path to the location of the file. The root of this path is defined by the table scope of this table.
Note: instead of a relative path you can use a url, which enables you to load a file from a webserver via HTTPS. Since the
If True, the values in the first line of the file will be used as the names of the attributes.
Contains the character that separates the fields in a line. This can either be the character itself, or the ASCII code of this character.
Contains the character that encloses fields within the file. Usually, this is not necessary, and none can be used.
Note: When fields can contain the
The encoding of the file defines how characters are parsed. Usually, this is UTF-8.
Follow these steps to create a new table using a connection string.
Right click in the Data tab and select New able -> Connection string....
A connection string table
Enter the connection string in the Connection String field.
Updated 2 months ago