About the Table node
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
You can use the Table node to specify that the values for a variable should be selected from the fields in a specific table. Because each table field has several values, you use the Look up tab to search for the line from which the field value should be taken. You specify the field and value as search criteria on this tab. The field and value determine the line from which the value of the field specified on the Field: tab will be taken. The field value will then be assigned to the variable specified on the same Field: tab.
Note
If more than one record in the table matches the lookup value or values, field values will be returned from the first record that was found. For example, if a lookup is performed for a specific customer number in the Sales orders table, the order number that is actually returned will be the number of the first order that was created for this particular customer.
If you want to transfer values from several fields, create one line for each field as follows:
In the Field name field, specify the name of the required table field.
In the Variable field, specify the variable that should receive each field value.
Example
A company uses special packing procedures to protect items that are delivered by mail. When an item is packed, you must know the net weight so that you can select the appropriate packing material.
If the variable ItemNo contains the number of the item for which the net weight is required, you can use the Table node to obtain information about the net weight of each item.
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).