Assign action in the Data Table package

The Assign action in the Data Table package enables you to assign values to a table variable.

Settings

Consider a scenario where you want to update data in an existing Data Table called Sales-numbers. You have created a variable called Manufacturers to temporarily store the Data Table values so that you do not lose the original data while you perform other tasks. You then use the Assign action to assign the values to Sales-numbers.
Note: Ensure that both the data tables have the same number of rows and column. In this scenario, both Manufacturers and Sales-numbers data tables have three rows and three columns.
  • In the Actions palette, drag the Assign action in the Data Table in to the editor.
  • The Source data table field has the following options:
    • Table with values - Enables you to select an existing pre-defined table.
      Use this option to select the Manufacturers variable.
      • Click the Variables tab.
      • Click the Insert a value icon.
      • Click the Choose a variable drop-down menu and select Manufacturers.
    • Table with no values - Enables you to define an empty table.
  • Click the Save the outcome to a variable drop-down menu and select Sales-numbers.
  • Click Save.

The Data Table values in the Manufacturers variable are now assigned to the Sales-numbers.