Page Comparison

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

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
  

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.
   
   

   

   
   

2. FactoryLogix analyzes the row and automatically determines the contents of the column.
   
   The results are shown in the 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.
   

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

• 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.
  

5. 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.