Manipulating more than one table
When tables other than the current one are used in an expression, Quantum compares the element texts of those tables with that of the current table. If the texts are identical, the elements are manipulated. If an element is present only in the current table, it appears in the table unmanipulated, whereas if it exists only in the previous tables, it is ignored. Elements which are present in both/all tables but have non-identical wording cause the manipulation to fail.
This need not prevent you from manipulating rows with different texts or in different positions in the tables because Quantum will also manipulate rows which have the same ID.
For example, in the following axes:
▪The two rows named B are dealt with together because their row texts are identical.
▪Rows A and Z is dealt with together because they both have the same identifier.
▪Row C is ignored because it only appears in the first table.
▪Row X, which is present in the second table only, appears in its original form.
tab ax01 bk01
tab ax02 bk01
ex +T@1
l ax01
col 156;Row A;%id=r3;Row B;Row C
l ax02
col 113;Row X;%id=r1;Row B;Row Z;%id=r3
l bk01
col 127;First;Second;Third
This might produce the following tables:
ax01 by bk01 (printed)
| First | Second | Third |
Row A | 10 | 6 | 13 |
Row B | 5 | 17 | 22 |
Row C | 18 | 14 | 3 |
ax02 by bk01 (not printed)
| First | Second | Third |
Row X | 12 | 20 | 2 |
Row B | 4 | 11 | 19 |
Row Z | 9 | 15 | 14 |
Final table (printed)
| First | Second | Third |
Row X | 12 | 20 | 2 |
Row B | 9 | 28 | 41 |
Row Z | 19 | 21 | 27 |
See also