transformations:exporttableau
This is an old revision of the document!
Table of Contents
EXPORT TO TABLEAU
Category: Export / File, Export / App & Cloud
Description
This action exports the current table into a Tableau Hyper or Data Extract (.tde) file, or publishes to Tableau Server/Tableau Online.
Action settings
Setting | Description |
---|---|
Export to | Select whether to export to a local file or to Tableau Server or Tableau Online. See the following tables for more details. |
Indicate column types | Explicitly define the data type for each column - number, text, or date. If EasyMoprh can't convert a cell value to a specified format, it will leave the cell empty (null). |
Export to Hyper or TDE file options
Option | Description |
---|---|
Hyper/TDE file* | The fully-qualified file name of the output Hyper or TDE file (includes relative or absolute path). |
File already exists | If a file with the same name already exists, choose whether to overwrite the existing file, rename the existing file, or halt the action's execution. See the following table for details. |
* Setting can be specified using a parameter.
File already exists options
Option | Description |
---|---|
Overwrite | The new file replaces the original file. |
Rename | The original file will be renamed with "backup" and a serial number appended to the file name. The new file will possess the name specified in the Hyper/TDE file setting. |
Halt project execution | The project will stop processing and this action will display a warning symbol. |
Export to Tableau Server/Tableau Online options
Option | Description |
---|---|
Connector* | Select the pre-created connector, or create a new connector, to the Tableau Server/Tableau Online to export to. |
Project* | Select the Tableau Server/Online project to publish to. The project name can be selected from a list, entered manually, or specified using a parameter. |
Data source* | Select the data source to replace or enter the name of a new data source. The data source name can be selected from a list, entered manually, or specified using a parameter. |
About (optional)+ | Enter the data source description that will appear in Tableau Server / Online. This setting is optional. |
Data source already exists options | |
Overwrite | The contents of the data source will be replaced with the new dataset. |
Append | The new dataset will be appended to the existing data source. |
Halt project execution | The project will stop processing and this action will display an error symbol. |
* Setting can be specified using a parameter.
+ Setting can be specified using an expression.
Remarks
Boolean values are converted to numbers - 0 for FALSE and 1 for TRUE.
Errors and empty cells are replaced with nulls.
When exporting to Tableau Server / Online, use the "About" field to store data source metadata such as the author. Note that appending data to an existing data source doesn't change its "About" property.
See also
transformations/exporttableau.1620983175.txt.gz · Last modified: 2021/05/14 05:06 by dmitry