MatchedCopyRow: Difference between revisions
Jump to navigation
Jump to search
(New page: == Operation == The operation will set the cells in the specified row (''result'') to the values contained within another row (''set to'') where the tuple name of the column(s)...) |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 5: | Line 5: | ||
Note: | Note: | ||
*The tables containing the rows | *The tables containing the rows do not need to be the same. | ||
*The position of columns is not important, as long as the tuple name matches. | *The position of columns is not important, as long as the tuple name matches. | ||
*The format of the columns is not important. | *The format of the columns is not important. | ||
| Line 43: | Line 43: | ||
<br> | <br> | ||
After applying the Routine Operation '''''MatchedRowpyRow(t.Display.Row(1),t.Information.Row(1))''''' | After applying the Routine Operation | ||
'''''MatchedRowpyRow(t.Display.Row(1),t.Information.Row(1))''''' | |||
The result will be '''''Display''''' Table: | The result will be '''''Display''''' Table: | ||
| Line 53: | Line 57: | ||
| '''''B''''' | | '''''B''''' | ||
|- | |- | ||
| Tue | | Tue | ||
| 15% | | 15% | ||
| Tony | | Tony | ||
|} | |} | ||
Latest revision as of 11:32, 16 February 2009
Operation
The operation will set the cells in the specified row (result) to the values contained within another row (set to) where the tuple name of the column(s) matches.
Note:
- The tables containing the rows do not need to be the same.
- The position of columns is not important, as long as the tuple name matches.
- The format of the columns is not important.
Example
Information Table (set to)
| A | B | C |
| 7 | Tony | Tue |
Display Table (result)
| C | K | B |
| Wed | 15% | Rick |
After applying the Routine Operation
MatchedRowpyRow(t.Display.Row(1),t.Information.Row(1))
The result will be Display Table:
| C | K | B |
| Tue | 15% | Tony |