TupleItemToRow

Operation

The operation will set cells in the specified row to the item attribute vaules where 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.