Differences

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

--- transformations:exporttableau [2016/09/20 23:17] – dmitry
+++ transformations:exporttableau [2021/05/09 00:26] – craigt
@@ Line 1: / Line 1: @@
-===== Export to Tableau Data Extract =====
+{{ transformations:ExportTableauAction.png}}
+======EXPORT TO TABLEAU======
+Category: Export / File\\
+\\
+=====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.|
+<sup>*</sup> Setting can be specified using a [[:parameters|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<sup>*</sup>| Select the pre-created connector, or create a new connector, to the Tableau Server/Tablau Online to export to.  |
+<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
+\\
+=====Remarks=====
+Boolean values are converted to numbers - 0 for FALSE and 1 for TRUE.
-This transformation exports table into a Tableau Data Extract file (.tde).
+Errors and empty cells are replaced with nulls.\\
-=== Parameters ===
+\\
+=====See also=====
-//File name// -- file name with a full or relative path.
+  *[[transformations:tableaucommand|Tableau Server Command]]
-//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).
-Boolean values converted to numbers - 0 and 1 for FALSE and TRUE respectively.
-Errors and empty cells replaced with nulls.