Skip to main content

tbl_parameter : SET (Power Query)

Overview​

This video demonstrates how to use the tbl_parameter SET command in Nitro-CELL with data sourced from Excel Power Query. Power Query enables engineers to pull data from external sources — such as databases, CSV files, or web services — and use it to drive parameter updates in Creo models. The video shows how to set up a Power Query connection, transform the data into the format expected by Nitro-CELL, and use the tbl_parameter SET command to apply the values to Creo model parameters. This approach enables dynamic, data-driven automation where parameter values come from external systems rather than being manually entered.

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 command referencing the Power Query table
  5. Execute the command to apply the external data as Creo parameter values

Tips​

  • Power Query connections can refresh automatically to pull the latest data
  • Use Power Query transformations to clean and format data before applying to Creo
  • This approach is ideal for integrating ERP or PLM data directly into Creo models