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 |
||
| 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 | ||
|} | |} | ||
Revision as of 15:21, 10 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 are not important.
- 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 |