Skip to main content

tbl_parameter : SET_CREATE (Power Query)

Overview​

This video demonstrates how to use the tbl_parameter SET_CREATE command in Nitro-CELL with data sourced from Excel Power Query. This combines the robustness of SET_CREATE — which creates parameters if they do not exist — with the dynamic data sourcing capabilities of Power Query. Engineers can pull parameter data from external systems like databases, ERP, or PLM platforms and apply it directly to Creo models. The video shows how to set up the Power Query connection, format the output for Nitro-CELL, and execute the SET_CREATE command to synchronize external data with Creo model parameters.

Key Steps​

  1. Set up a Power Query connection to your external data source
  2. Transform the query output to match the Nitro-CELL table format
  3. Load the Power Query results into an Excel table
  4. Enter the tbl_parameter SET_CREATE command referencing the Power Query table
  5. Execute the command to create and set parameters from external data

Tips​

  • Power Query enables real-time data synchronization between external systems and Creo
  • Use Power Query transformations to clean and validate data before applying to models
  • This approach is ideal for keeping Creo models in sync with ERP or PLM master data