BOM (Bill of Materials)
      Back to home
      1. LearnCQ
      2. QuoteCQ
      3. BOM (Bill of Materials)

      QuoteCQ Smart BOM Import: How to bulk update and/or delete data

      Do less scrubbing by using the bulk update and delete rows when importing a BOM

      Bulk Update Operations

      In the example above, we updated the Part Class from Default Default to SMT 0805 when the description contains a 0805 value.

      1. Column selection drop-down: This drop-down shows the column options as your Last Mapped data stage. You'll need to select the column where you want to apply the bulk update.
        If you want to apply bulk updates to all columns, leave this field blank.

      2. Equals/Not Equals/Contains: Choose the filter logic that suits your Current Value.

      3. Current Value: Write the existing value which you want to update.

      4. New Value: Write the new value you want to replace with the Current value.

      5. Select the Check box if you want to Conditional update using another column value

      6. When: This field will be useful to set the conditioning format.

      Bulk Delete Rows

      You can easily delete multiple rows by setting up two conditioning formats with the desired column contents.

      In the above example, the system only deletes the row if the Description column contains 0805 and Part Class column equals Default Default value.