Page Comparison

...

You can set up sheet names, resize columns, collapse and show columns, rename worksheets, import worksheets from other workbooks, and more.

Anchor
sheet_

...

There are multiple ways to navigate between sheets within a workbook:

• Click the sheet tab you want to view a the bottom of the page.
• Select the Sheets menu and click the sheet you want to view.
• Click on the Sheet Dependencies button in the toolbar and switch between sheets by clicking on sheets that are dependent with each other

Renaming sheets

To change the name of a sheet:

1. Right-click the sheet name and click Rename.
2. Enter the new name and press Enter.
3. To undo the change, right-click the name again and click Undo.

Deleting sheets in a workbook

To delete a sheet:

1. Click the tab in the workbook that you want to delete.
2. Right-click the tab and choose Delete.
3. Click Delete.

Duplicating sheets in a workbook

You can duplicate workbook sheets. New sheets are named with the next available number appended to the sheet name.

 To duplicate sheets in a workbook:

1. Click the tab in the workbook.
2. From the Workbook menu Sheets, select Duplicate  Sheet or right-click the sheet tab and select Duplicate.
3. In the Duplicate Worksheet, select the columns you want to copy to the new sheet and click Create  Sheet  Copy.
4. If a sheet has actions applied to it, you have the option to copy both the logic and the data, or you can select the Copy data onlycheckbox to copy just the data.

...

In addition to the raw data of a sheet with formulas, joins, sorts, or clustering, you can also copy the underlying logic and actions of a sheet into a new sheet.

...

To reorder sheets within a workbook:

1. Right-click the sheet tab.
2. Select Move.
3. Click the space between the current sheet tabs where you want the selected sheet to be placed.

...

To reorder columns in a sheet:

1. Left-click and drag the column name to the desired position.

Anchor
sheet_dependency sheet_dependency

Displaying sheet dependency (graph overlay)

...

1. View the sheet dependency overlay by clicking the Sheet Dependencies button in the toolbar. The currently selected sheet will be highlighted in the middle of the graph.
2. To navigate between dependent sheets, click the sheet name located on the graphic overlay.
3. To close the sheet dependencies overlay, click the toolbar button or click X on the current sheet.

Anchor

...

Importing sheets allows you to chain workbooks together. 

To import sheets from one workbook into another workbook:

1. Open the workbook you want to import the worksheet into.
2. From the Workbook menu, select Add Data, or click the Add Data icon on the toolbar.
3. First, select the workbook you want to use and click Add Data.
4. Then select the sheets you want to import and click Add Data.
5. The new worksheet tabs are added to the right of the existing worksheets.

Anchor
set_up_col set_up_col

Column names

When a user creates new columns using the Formula Builder, Datameer X creates default column names based on the column name in the formula, and the formula type.

...

1. Right-click on the column name and click Rename.
2. Enter the new name and press Enter.
3. To undo the change, right-click the name again and click Undo.

Resizing columns

To resize columns:

1. Place the mouse between two column headings so the icon changes to a double-ended arrow.
2. Drag the column marker to the desired width.
3. Click to lock the width.

You can also double-click a column name to fully expand the column.

...

To hide (collapse) a column, right-click the column name and select Hide Column. 

Double-click the hidden column to bring it back into view.

Image Removed 

A toggle columns toolbar button displays all columns of the current worksheet. You can use this menu to show or hide columns as a batch process.

Image Removed 

...

To insert a new column:

1. Right-click a column name.
2. Select Insert Column. A new column is added to the left of the chosen column. INFO: Each workbook can contain a maximum of 702 columns.

...

To remove a column:

1. Right-click a column name.
2. Select Remove Column.

Anchor
cell_context cell_context

Cell context menu options

...

• Copy - Copy the cell value to the clipboard.
• Filter by - A shortcut to open the filter feature and auto completes the fields using the equals expression to filter for matches the cell's value.
• Exclude - A shortcut to open the filter feature and auto completes the fields using the does not equal expression to filter for matches that don't match the cell's value.

...

Datameer 7.5 includes the option to split workbook string and list type column content by a selected delimiter. Several optional additional controls are available. Resulting column names are the original column name with a sequential number appended. For list columns, commas are the only delimiter and there will be one column per comma up to the column limit.

The split column operation can be updated as many times as you like until you have desired split configuration.

To split a column:

...

The following optional controls are available:

• (Strings only) Use Skip Leading to enter the number of characters that will be ignored before the delimiter used to split the column.
• (Strings only) Use Skip Trailing to enter the number of characters that will be ignored after the specified number of columns are split.
• Use Skip first to ignore the first x number of elements, where elements are the characters between delimiters.
• Use Split into to specify a fixed number of columns into which data will be split.
• (JSON array only) When Catch additional data in overflow column is checked, if the number of original elements exceeds the number of specified output columns, the remaining elements will be kept and grouped into one column, in brackets.
  
• Use Drop additional elements to ignore all elements past the specified output columns. 
• (Strings only) Use Trim Whitespace to delete any leading or trailing spaces and line breaks.
  
• (Strings only) Use Define Empty Value to specify what is substituted in if no existing data is split into the last columns (i.e. when the amount of data is smaller than the column limit.)

      5. Optionally, enter a Column prefix that be prepended to the new column names. 
      6. Once you have entered your desired parameters, click Create Sheet. 
      7. A new SplitString or SplitList sheet opens containing the split columns.

If desired, you can use the Split tab in the Inspector to enter new split criteria. Click Update Sheet to apply changes.

...

• value

...

• .

...

1. Right-click on the column header of the column you want to encode and select Encode Column from the context menu, use the menu option Edit > Encode Column, or click on the Encode Column icon in the toolbar.  
   Image Removed 
   
2. In the Encode Columns dialog, the Input column will be selected automatically. 
3. Select the Type of encoding, either Ordinal Encoding or 1-Hot Encoding. For dates and integers, Binned Encoding is also an option, where values are grouped and elements in a group are encoded the same way. 
   Image Removed
4. Unknown Values controls how values beyond the 100 most frequent values are processed. Drop value ignores values beyond the first 100 most frequent. Include as last column adds a new element to the list that encodes together all values beyond the 100 most frequent. 
   
5. The bottom of the dialog displays the top 15 values, and also provides a blank field where you can add new values. You can click on value in the list to change its order or remove it, or type in the blank field to add a new value.
   Image Removed 
   
6. Output Encoding determines how many columns the data will be divided into. For 1-hot encoding, you have the option to output As Columns, which spilts each binary pair into its own column, or As List, which keeps all binary pairs together in a single column. Similarly, for binned encoding choose As Columns to create binary pairs each in their own column, or Ordinal to encode as ordinal numbers in a single column.
7. For binned encoding, Bin Dividers determine the number of bins, and the highest value for each bin divider determines the value distribution in each percentile. You can use Add new Divider to add a new bin. You can change the highest value in a given bin by selecting a different value. For dates, set the Date Bins by option to day, hour, month, quarter or year. 
   In the example shown below, years between 1999 and 2006 will be grouped and encoded together, 2007 to 2011 in the next, 2012 to 2018 in the next, and 2019 to 2021 in the last.       
   Image Removed 
   
8. Click Encode. The new encoded columns are added in an EncodingSheet.

Once encoding is initiated you can use the Encoding tab of the Inspector to add to or change encoding criteria. Click Update to apply changes.

Anchor
format_column format_column

Formatting columns

...

...