Workbook Tab User Interface

INFO

The Workbook tab is Datameer X's User Interface for showing, managing and preparing data within a workbook.

Overview

Number	Name	Functionality
1	Datameer X tab	opens the Datameer X web homepage
2	Workbook Icon bar	displays all available icons for workbooks
3	File Browser tab	navigates back to the File Browser
4	Menu bar	lists all menu tabs for the Workbook tab
5	'Add' button	quick start to add workbooks, connections, etc.
6	Workbook tab	displays the content of an opened workbook
7	Workbook Inspector	lists all information and managing options for a workbook
8	Date and time information	displays the current date and time information
9	Tab navigation	option to switch between all open tabs in the tab bar
10	Sheet 'Add' button	adds a new sheet within a workbook
11	Sheet tab	lists all sheets in a workbook, e.g. formula sheet, data mining sheet, etc. depending on the
12	Initial sheet tab	initial workbook sheet
13	Table	contains workbook content

Number	Name	Functionality
1	Account	account settings Datameer X version information logout
2	File	creating a new workbook open an existing workbook add data to a workbook exchange data saving and duplicating a workbook running a workbook show details and browse all data configure a workbook close a workbook
3	Edit	undo and redo an action filter, sort, join and union data partition data and deduplicate pivot sheet split and encode columns
4	Sheets	add and duplicate a sheet add a SQL sheet add an Export sheet duplicate a Sheet view the latest sheets
5	View	view the job graph flip the sheet show th dependencies graph go to a line or jump to column or sheet jump to column or sheet by name toggle columns display the Workbook Inspector and/ or the 'Admin' tab
6	Help	link to user documentation

Number	Name	Functionality
1	Add Data	add data
2	Save	save the data
3	Run	run the workbook
4	Browse All Data	browse all data
5	Undo	undo the last action
6	Redo	redo the last user action
7	Filter	filter data
8	Sort	sort data
9	Join	join data
10	Union	union data
11	Partition	partition data
12	Deduplicate	deduplicate data
13	Pivot	create a pivot table
14	Add Export Sheet	add an export sheet
15	Split Column	split a column
16	Encode Column	encode the column
17	Job Graph	show the job graph
18	Flip Sheet	flip the sheet
19	Dependency Graph	show the dependency graph
20	Expand All Columns	expand all columns cells
21	Go to Line	go to a specific line
22	Jump to Column or Sheet	jump to a specific column or a sheet
23	Toggle Columns	toggle the columns
24	Inspector	show the Workbook Inspector

INFO

The Workbook Inspector provides information about sheets, columns and formula, depending to the workbook type and content.

Number	Name	Functionality
1	'Sheet' tab	contains sheet related information
2	Sheet type	displays the sheet type, e.g. formula sheet
3	Columns options	displays all sheet columns and corresponding data type
4	Sheet description	displays a sheet description or option to enter s sheet description
5	'Column' type	contains column related information
6	Column name	displays the column name
7	Column description	displays a column description or option to enter a column description
8	Data profile	displays data profile with visual information, e.g. rows with values, number of unique data
9	'Formula' tab	contains all functions that you can apply to a sheet
10	Formula search	search bar to find appropriate formula for data preparation
11	Formula	displays all selectable formulas
12	Formula description	provides information about a formula, e.g. formula syntax, formula description
13	Formula settings field	displays options to modify and customize the formula
14	'Add to Formular' button	adds the selected formula to the sheet
15	'Browse Columns'	browses the columns