Skip to main content

tbl_parameter : COPY (Power Query)

Overview​

This video demonstrates using the tbl_parameter COPY command with Power Query data in Nitro-CELL to copy parameters between Creo models using a dynamically populated Excel table. Power Query pulls the source-target model mappings and parameter names from an external data source, enabling fully data-driven parameter propagation workflows. This approach is ideal when the copy mappings are maintained in an external system such as a CSV file, database, or another workbook, and need to be refreshed before each execution. The video covers setting up the Power Query, linking it to the COPY command, and executing the workflow.

Key Steps​

  1. Create a Power Query that retrieves source-target model mappings and parameter names
  2. Load the query results into an Excel table
  3. Enter the tbl_parameter COPY command referencing the Power Query table
  4. Refresh the Power Query to get the latest mappings before execution
  5. Execute the command to copy parameters based on the Power Query data

Tips​

  • Refresh Power Query before each run to ensure current data
  • Power Query can join data from multiple sources to build copy mappings
  • Combine with tbl_parameter GET to verify copied values after execution