Versions Compared

Old Version 9

changes.mady.by.user Adriane Hunt

Saved on

compared with

New Version 10

changes.mady.by.user Adriane Hunt

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip

Tip

  • You can use the toolbar buttons or right-click rows and columns to access editing options.

  • Drag between two column headers to make a column wider or narrower.

  • Standard Cut, Copy, and Paste editing commands are available for selected cells when you right-click a cell (you can undo these actions using Ctrl+Z).

Edit rows

Editing rows

Description

Filter

Removes all rows that contain the specified text from the selected cell in a column.

Filter Matching Options specify the position of the filter text within the search:

  • Starts With - If the specified filter text appears at the beginning of a cell, the entire row is removed

  • Contains - If the specified filter text appears anywhere within a cell in the selected column, the entire row is removed

  • Ends With - If the specified filter text appears at the end of a cell, the entire row is removed

Editing rows

Description

Filter

Removes all rows that contain the specified text from the selected cell in a column.

Filter Matching Options specify the position of the filter text within the search:

  • Starts With - If the specified filter text appears at the beginning of a cell, the entire row is removed

  • Contains - If the specified filter text appears anywhere within a cell in the selected column, the entire row is removed

  • Ends With - If the specified filter text appears at the end of a cell, the entire row is removed

    Filter Rows dialog

Map Row to Column Headers

Maps the row of headers at the top of the BOM that define the data in each column to informational rows to define each column in the BOM.

  1. Select the row containing the informational headers (if it exists), then select Map Row to Column Headers on the toolbar.

    BOM Formatting page


  2. FactoryLogix analyzes the row and automatically determines the contents of the column.

    The results are shown in the Map Column Headers dialog.

    Map Column Headers dialog


  3. If necessary, modify the information further if desired using the Column Definition drop-downs to map different or additional column headers.

Note

You can also modify individual column definitions on the BOM Formatting page by right-clicking a column header and selecting a new column definition from the menu.

  1. (Optional) Right-click a column header to display commands for sorting, filtering, grouping, and organizing column data.

Column editing commands

  • Sort Ascending - Sorts all column data in A-Z order.

  • Sort Descending - Sorts all column data in Z-A order.

  • Clear Sorting - Removes all sorting from column data and returns it to its original order.

  • Group by This Column - Groups data by the selected column.

  • Show Group Panel - Displays the message "Drag a column header here to group by that column". You can drag any column header onto the message to group by that column. When you see a Red X, the grouping is performed.

  • Hide Group Panel - Hides the grouping panel and message at the top of the dialog.

  • Show Column Chooser - Displays a dialog to show you which column is currently selected for grouping.

  • Best Fit - Fits selected column data to an ideal width.

  • Best Fit (all columns) - Fits all column data to an ideal width.

  • Filter Editor - Displays a dialog where you can specify filtering criteria for BOM data.

  • Show Search Panel - Displays the Search bar so you can search the selected column for specific data.

Note

The Filter Editor is also used in DataMiner (Analytics) and the Trace window (Production) For details about using the Filter Editor, see Filter BOM column data.


Filter Editor for BOM column data


  1. When you are satisfied with the BOM column data, select OK to return to the BOM Formatting page.

Delete Rows

Deletes selected rows of data from the BOM.

...