Differences

This shows you the differences between two versions of the page.

--- transformations:exporttableau [2016/09/20 23:17] – dmitry
+++ transformations:exporttableau [2021/05/14 05:10] (current) – dmitry
@@ Line 1: / Line 1: @@
-===== Export to Tableau Data Extract =====
+{{ transformations:ExportTableauAction.png}}
+======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<sup>*</sup>| 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.|
+|**File already exists options**||
+|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.|
+<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
+\\
-This transformation exports table into a Tableau Data Extract file (.tde).
+====Export to Tableau Server/Tableau Online options====
+^Option ^Description ^
+|Connector<sup>*</sup>| Select the pre-created connector, or create a new connector, to the Tableau Server/Tableau Online to export to.  |
+|Project<sup>*</sup>| 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<sup>*</sup>| 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)<sup>+</sup>| 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.|
+<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
+<sup>+</sup> Setting can be specified using an [[syntax:start|expression]].
-=== Parameters ===
+\\
+=====Remarks=====
+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.
-//File name// -- file name with a full or relative path.
+Boolean values are converted to numbers - 0 for FALSE and 1 for TRUE.
-//Column types// -- TDE requires explicit specification of column types - number, text or date. If EasyMorph can't convert a cell value to a specified format it will leave empty cell (null).
+Errors and empty cells are replaced with nulls.
-Boolean values converted to numbers - 0 and 1 for FALSE and TRUE respectively.
+[[syntax:types|Numbers in EasyMorph]] are converted into floating-point values in Tableau which may potentially lead to a loss of precision as numbers in EasyMorph allow more digits after the decimal point.
-Errors and empty cells replaced with nulls.
+\\
+=====See also=====
+  *[[transformations:tableaucommand|Tableau Server Command]]