#91 - Intersection, Union, And Difference in the Case of Simple Members - Two Sets

PublishedNovember 7, 2024

•1 min read

#91 - Intersection, Union, And Difference in the Case of Simple Members - Two Sets

esProc SPL is a JVM-based programming language designed for structured data computation, serving as both a data analysis tool and an embedded computing engine. FREE download👉🏻: https://www.esproc.com/download-esproc

Problem description:

The following table lists the top 10 products by sales in January and February:

Solutions:

Use SPL XLL and deal with the following tasks respectively.

A. Find out the products that make the top 10 in both January and February:

=spl("=?1^?2",B2:B11,C2:C11)

B. Find out the products that make the top 10 once or more:

=spl("=?1&?2",B2:B11,C2:C11)

C. Find out the products that make the top 10 in January but fail to make the top 10 in February:

=spl("=?1\?2",B2:B11,C2:C11)

D. Find out the products that make the top 10 in February but fail to make the top 10 in January:

=spl("=?2\?1",B2:B11,C2:C11)

Download esProc Desktop for FREE and level up your Excel skills!!! 🚀🔥⬇️

✨SPL download address: esProc Desktop FREE Download

✨Plugin Installation Method: SPL XLL Installation and Configuration

✨References to other rich Excel operation cases: Desktop and Excel Data Processing Cases

✨YouTube FREE courses: SPL Programming

#excel #excel-tutorial #excel-sheets #productivity #programming-blogs #codenewbies #learn-coding #data-science #data-analysis #dataanalytics #tutorial

Comments (1)

Join the discussion

esProc1y ago

Discover how SPL XLL can make your work smoother and more efficient with the rest of the communities!

✅Discord:https://discord.gg/cFTcUNs7 ✅Reddit: https://www.reddit.com/r/esProc_Desktop/

More from this blog

Query the Records Closest to the Specified Time Each Day — From SQL to SPL #43

Problem Description & Analysis: A table in Oracle database has a column of datetime type, corresponding to multiple pieces of data per day: Task: Now we need to find two records every day, one closest to 8am that day and one closest to 8pm that day....

Jun 26, 20251 min read

Query the Records Closest to the Specified Time Each Day — From SQL to SPL #43

Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42

Problem Description & Analysis: A certain table in the MS SQL database has three fields: account, date and time of string type. Task: Now we need to add a sequence number column Seq for the group. When a new event occurs for an account within one ho...

Jun 23, 20252 min read

Generate Event Sequence Numbers within a Specified Time Interval — From SQL to SPL #42

Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41

Problem Description & Analysis: The query results of the Postgresql database return 6 columns, with the first column being the grouping column, the second column being the Value column within the group, and columns 3–6 being the Key columns within th...

Jun 20, 20252 min read

Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41

Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

Problem Description & Analysis: A table in an Oracle database has multiple string fields. Task: Now we need to input a parameter that contains multiple strings separated by commas. We need to find the records in the table that contain all these stri...

Jun 18, 20252 min read

Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39

Problem Description & Analysis: In a certain view of the PostgreSQL database, the row_index field is an underscore separated string and also a grouping field. Some groups’ row_index can be divided into 3 parts, while others can be divided into 2 part...

Jun 16, 20252 min read

Add Records that Meet the Criteria before Each Group after Grouping — From SQL to SPL #39

Untitled Publication

207 posts

Command Palette

Problem description:

Solutions:

Comments (1)

More from this blog