Skip to main content

DESCRIPTION Parameter Cleanup via Excel Tables and Power Query

Overview​

This video demonstrates a practical workflow for cleaning up DESCRIPTION parameters across multiple Creo models using Nitro-CELL with Excel tables and Power Query. The DESCRIPTION parameter is commonly used in Bills of Materials and documentation, and inconsistencies in its values can cause issues in downstream processes. This workflow uses Power Query to pull current DESCRIPTION values from models, applies cleanup transformations in Excel (such as trimming whitespace, standardizing capitalization, or correcting typos), and then writes the corrected values back to the models using tbl_parameter commands. The video walks through the complete end-to-end process.

Key Steps​

  1. Use tbl_parameter GET to extract current DESCRIPTION values into a table
  2. Set up Power Query transformations to clean and standardize the values
  3. Review the cleaned values in the Excel table before applying
  4. Use tbl_parameter SET to write the corrected DESCRIPTION values back to models
  5. Save the updated models to persist the changes

Tips​

  • Always review cleaned values before writing them back to models
  • Power Query transformations can handle trimming, case changes, and replacements
  • This workflow applies to any parameter, not just DESCRIPTION