List of Supported Formats

Search the Online Transformer Gallery

You are here: New Formats for 2016+Tableau Data Extract (TDE) WriterTDE Writer Feature Type Properties: User Attributes

TDE Writer Feature Type Properties: User Attributes

For information on the parameters in this dialog that are specific to all formats, see About Writer Feature Types: User Attributes

User attributes for this format are defined below.

Name

The name of the attribute to be written.
Type

The type of a column in a table. The valid values for the column type are listed below:

Closedboolean

Boolean fields store true/false data. Data that is read from or written to these fields must always have a value of either true or false.

Closedcharstring (string)

String fields store variable-length character data up to a length of 32767 characters.

Values larger than 32767 are truncated.

Closeddate

This type is used to represent date data from January 1, 1000 to December 31, 9999. The date values are represented as MM/DD/YYYY in Tableau. For example, January 10, 1000 would be represented as 1/10/1000.

Date values must also be valid days according to the Georgian calendar. For example, April 31 and February 29, 2015 are not valid date values.

Parameters

  • year: the year (value must be a 4 digit year)
  • month: the month (value must be 1-12)
  • day: the day (values must be 1-31)

See Standard FME Date and Time Format for information about the formatting of FME date and time as input produced by the reader for date cells. See the Formatting section below for the options for custom number formatting, which also applies to date types

Closeddatetime

This type is used to represent date and time data from January 1, 1000 to December 31, 9999 with an accuracy of 0.1 millisecond. The date time values would be represented as MM/DD/YYYY HH:MM:SS (AM/PM) in Tableau.

Parameters:

  • year: the year (value must be a 4 digit year)
  • month: the month (value must be 1-12)
  • day: the day (values must be 1-31)
  • hour: the hour (values must be 0-23)
  • minute: the minute (values must be 0-59)
  • second: the second (values must be 0-59)
  • fraction: the fraction of a second in tenths of a millisecond (values must be 0-9999)

The fraction of a second (fraction parameter) is used to round the Datetime data type to the appropriate value in seconds. If the fraction parameter is between 5001-9999, the Datetime data is rounded up a second. For example, the Datetime data 1/1/2010 10:00:05 AM with a fractional second value of 5001-9999 will be displayed as 1/1/2010 10:00:06 AM.

See Standard FME Date and Time Format for information about the formatting of FME date and time as input produced by the reader for date cells.

Closeddouble

Number fields store single- and double-precision floating point values.

Closedinteger

Number field that can store either 32-bit signed integers or 64-bit signed integers.

The range for 32-bit integers is -2,147,483,648 - 2,147,483,647.

The range for 64-bit integers is −9,223,372,036,854,775,807 to 9,223,372,036,854,775,807.