Prepare to import data into Tableau

Follow the steps in Prepare databases for FileMaker Data API access to define the layout for importing and to enable the database for FileMaker Data API access.

Note  To import data into Tableau, the table must have at least one record with record data.

The following FileMaker field types are imported as Tableau data types.

FileMaker field type	Tableau data type
text	string
date	date
time	string
timestamp	datetime
number	float

The following FileMaker field types are not supported when importing into Tableau:

• container fields

• summary fields. You can create a summary field in Tableau based on data that you import from FileMaker.

• calculation fields. You can create a calculation field in Tableau based on data that you import from FileMaker.

• chart data

• data from FileMaker Pro portals. To import data from related records, create a FileMaker Pro layout based on the related table, or import data from separate FileMaker Pro tables into Tableau and then join the tables in Tableau.

• field repetitions where the display of repeating fields for Show repetitions includes multiple values. A single repetition is supported.

• non-numeric values in number fields. If Tableau finds non-numeric values in number fields, the data will not be imported.

Do not use reserved words as field names in FileMaker Pro.