# How to Judge Equality and Belongingness Between Sets Regardless of Order

## Examples

### Example 1: Equality of sets

There is an Excel file Book1.xlsx, and the data is as follows:

 code order A 1 A 2 A 3 A 4 B 1 B 2 B 4 B 3 C 4 C 2 C 3 C 1

There is an Excel file standard2.xlsx, and the data is as follows:

 order 1 2

The task is to select all the data whose order value in Book1 is also the order value in standard2.

Write SPL script:

 A 1 =file("Book1.xlsx").xlsimport@t() 2 =file("standard2.xlsx").xlsimport@t() 3 =A2.(order) 4 =A1.select(A3.pos(order))

A3 The order data in standard2

A4 The pos function judges whether the order in Book1 belongs to A3, and filters the data according to the result of judgment. The results are as follows:

 code order A 1 A 2 B 1 B 2 C 2 C 1

### Example 2: Belonging to or containing

There is an Excel file Book1.xlsx, and the data is as follows:

 code order A 1 A 3 A 5 A 7 B 2 B 4 B 6 B 8 C 1 C 2 C 3 C 4

There is an Excel file standard2.xlsx, and the data is as follows:

 order 1 2

For the same code in Book1, select all the data where the order column contains all the code data of the order value in standard2.

Write SPL script:

 A 1 =file("Book1.xlsx").xlsimport@t() 2 =file("standard2.xlsx").xlsimport@t() 3 =A2.(order) 4 =A1.group(code).select(A3^~.(order)==A3).conj()