Replacing Tables
The Data Model provides functionality for replacing tables. To replace a table, click the context menu icon and select Replace.
Select a table for replacement from the local directory. To do this, drag the file into the upload field or click on the field and select the file.
When uploading a table, specify the following:
- Separator (
;— semicolon,,— comma,|— pipe,/— slash, tab, space, or other) - Qualifier (
'— single quotes or"— double quotes) - Encoding (UTF-8, UTF-8 BOM, or Windows-1251)
Click Continue.
After the action is confirmed, you will be directed to the working space where:
- The first row contains the column names of the new table
- The second row contains the column data types
Column data types are automatically determined, but can be modified if needed.
If a column participating in a link is deleted during table replacement, the link will also be deleted.
After clicking Replace in the upper right corner, you will be redirected to the Data model.
The "Engine" parameter cannot be changed.
For successful replacement, the data structure of the new table must match the current structure or expand it. If the user uploads a table but does not configure it (for example, have closed the tab), then to proceed with configuration, they must upload the table again.
Was the article helpful?