Description:
The operation generates a new sequence by merging two sequences.
Syntax:
A&B
A&x
Generate a new sequence by merging the members (or single values) from two sequences A and B in proper order. The common members will not appear repeatedly in the new sequence.
Parameter:
A |
A sequence with the length of n |
B |
A sequence with the length of m or a single value; When it is a single value, it is regarded as [B] |
Return value:
A new sequence after merging the two sequences A and B
Example:
|
A |
|
1 |
=[1,2,3,4]&[3,2] |
[1,2,3,4]. If members of the two sequences are not arranged in the same order, then follow the order of the first sequence. |
2 |
=[1,2,3,3]&[1,3] |
[1,2,3,3]. Duplicate members will not appear repeatedly, but the same members in the former sequence will be retained. |
3 |
=[1,2,3,3]&4 |
[1,2,3,3,4] |
4 |
=4&[1,2,3,3] |
[4,1,2,3,3] |
Related function: