• esProc
Tutorial
Function Reference
Code Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

Union of sequences

Read（2296） Label: sequences, union, new sequence,

Description:

The operation generates a new sequence by merging two sequences.

Syntax:

A&B

A&x

x&A

Note:

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: