Table sequence constant

Read(27) Label: constant, json,

Description:

A table sequence constant displayed in JSON style.

Syntax:

[{Fi:…,…},…]

Note:

A JSON style table sequence constant expression is used in a constant cell or in a parameter.

Parameters:

Fi

Name of a column in the table sequence

Return value:

A table sequence

Example:

  Cellset parameter:

 

 

A

 

1

=arg1

Result:

2

[{name:Jone,score:435},{name:Mary,score:677}]

Result:

XOR-enabled sequence

Description:

Generate a new sequence by arranging distinct members (or single values) in two sequences.

Syntax:

A%B

Note:

The operator enables a new sequence by arranging distinct members (or single values) in sequenceA and sequence B. Won’t repeate distinct operation over same members.

Parameters:

A

An integer sequence

B

A sequence or a single value; treated as sequence [B] when it is a value

Return value:

A sequence

Example:

 

A

 

1

=[1,2,3,4]%[2,3]

[1,4]

2

=[1,2,3,3]%[1,3]

[2,3]; won’t repeat distinct operation over same members

3

=[1,2,3]%3

[1,2]

4

=[1,2,3,3,4]%[1,1,3]

[2,3,4,1]

Related functions:

Difference between Sequences

Intersection of sequences

Union of Sequences

Alignment arithmetic operations

cmp()