Page tree

Trifacta SaaS



Contents:


   

Feature Availability: This feature is available in the following editions:

  • Trifacta® Enterprise Edition
  • Trifacta Professional Edition
  • Trifacta Premium

NOTE: The Trifacta® data types listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

Access/Read

NOTE: Image, Link, and Address fields from SharePoint are imported into Trifacta as JSON strings. Incorrect formatting or modification of these strings within the product may result in errors when published back to SharePoint Lists.


Source Data TypeSupported?

Trifacta Data Type

Notes
Choice (menu)YString
CurrencyYFloat
Date and TimeYDatetime
Link and ImageYString (JSON)
LookupYString
AddressYString (JSON)
Multiple lines of textYStringLines in the source are demarcated in the String value using the newline character.
NumberYFloat
Person or GroupYString (JSON)
Single line of textYString
Task outcomeYString
Yes/NoYBoolean

Publish/Write

Trifacta Data Type
SharePoint List Data TypesNotes
String

String

Note

Text

Varchar

URL

Choice

NOTE: Secondary types are published only if appending or truncating an existing table. See below.

IntegerInteger 
Decimal

Float

Currency

 
DatetimeDate and Time
BoolBoolean 
Map

Note

String

Text

Varchar

NOTE: Secondary types are published only if appending or truncating an existing table. See below.

Array

Note

String

Text

Varchar

NOTE: Secondary types are published only if appending or truncating an existing table. See below.

All other data typesString 

For more information, see http://cdn.cdata.com/help/RSF/jdbc/pg_datatypemapping.htm.

Depending on the publishing action, output data types may vary.

Appending or truncating a SharePoint List:

If you are appending or truncating an existing SharePoint List, all column data types are published to the target data types as expected, as long as the data being published can be parsed and published by SharePoint.

Writing to a new SharePoint List:

Some data types in  Trifacta do not have a direct mapping to SharePoint List data types. Examples:

  • Address, Link, Person, Choice, and Image data types are published to SharePoint Lists as a multi-line String.
  • Currency is published as a Number.
  • Datetime values in  Trifacta are written back to SharePoint Lists as DateTime types, even if the source data from SharePoint is Date type.

This page has no comments.