TupleRowToItem

Operation

For the specified row, the operation will set item attributes that have the same name as the column names of the specified table.

Note:

• Numerical values will be set regardless of the formatting of the columns (cells) or item attributes.
• Matching item attribute and column names are NOT case sensitive.

 

Example

An item has the following attributes (only):

i.ID = 1111

i.Colour = Blue

i.Size = Large

A table named Location exists as follows:

ID	Name	Colour	Location
2345	Turner	Red	Hobart
3523	Lisbon	Green	Brighton

 

Applying the Routine Operation TupleRowToItem((t.location.Row(2))

Would set the item attributes to the following values:

i.ID = 3523

i.Colour = Green

Note:

• i.Size remains unchanged as it doesn't appear as a column in the table.
• i.Location doesn't exist so it is not set.