3.28 Perform set-oriented computations on two small data files
Perform a desired set-oriented operation on two data files.
Based on running club member table and ball club member table, get members in the two clubs, people who join in at least one club, those who are members of both clubs at the same time, and those who are members of running club only.
| A | |
|---|---|
| 1 | =T(“running.xlsx”).([NAME,SURNAME]) |
| 2 | =T(“ball.xlsx”).([NAME,SURNAME]) |
| 3 | =A1|A2 |
| 4 | =A1&A2 |
| 5 | =A1^A2 |
| 6 | =A1\A2 |
A1 Get members of running club.
A2 Get members of ball club.
A3 Concatenation of A1 and A2.
A4 Union of A1 and A2, which are people who join in at least one club.
A5 Intersection of A1 and A2, which are people who join in both clubs.
A6 Difference of A1 and A2, which are people who join in running club only.
SPL Official Website 👉 http://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc
SPL Learning Material 👉 http://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/ydhVnFH9
Youtube 👉 https://www.youtube.com/@esProc_SPL
