TupleItemToRow

Operation

For the specified row, the operation will set cells in the row to the item attributes vaules provided the column name has the same name as the item attribute.

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 TupleItemToRow((t.Location.Row(2))

Would set the second row values to the following values:

ID	Name	Colour	Location
2345	Turner	Red	Hobart
1111	Lisbon	Blue	Brighton

 

Note:

• Column Location and Name remains unchanged as there is no item attributes called Location nor Name.