Workbook Sheet Types

Data mining sheet

a smart analytics sheet

Data Source

refers to an import job, data link or file upload

Export Sheet

a sheet that writes directly to a Data Warehouse when the workbook is run

External sheet

a sheet within another worksheet

Formula sheet

a sheet in which Datameer X formulas apply

Join sheet

a joint of two sheets

SQL sheet

a sheet in which SQL formulas apply

Union sheet

two sheets with the same schema

Pivot sheet

a sheet with pivot data where rows are transposed to columns in order to group and aggregate data

Deduplicate Sheet

a sheet with eliminated duplicate or redundant data

JSON sheet

a sheet with parsed columns from the JSON format