8.5 Intersection, union and difference in the case of row-based data - multiple sets
There is a file top10Sales.xlsx, which lists the sales data of the top 10 products by sales in the first couple of months of the year (the number of months will increase over time):
Find out the products that make the top 10 in every month of these months:
| A | |
|---|---|
| 1 | =file(“top10Sales.xlsx”).xlsopen() |
| 2 | =A1.(A1.xlsimport@t(;stname)).merge@oi(ProductName) |
Find out the products that make the top 10 once or more:
| A | |
|---|---|
| 1 | =file(“top10Sales.xlsx”).xlsopen() |
| 2 | =A1.(A1.xlsimport@t(;stname)).merge@ou(ProductName) |
Find out the products that make the top 10 in January but fail to make the top 10 in any of other months:
| A | |
|---|---|
| 1 | =file(“top10Sales.xlsx”).xlsopen() |
| 2 | =A1.(A1.xlsimport@t(;stname)).merge@od(ProductName) |
https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1655257446201
https://c.scudata.com/article/1655342302228
SPL Official Website 👉 https://www.esproc.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 https://c.esproc.com
Discord 👉 https://discord.gg/2bkGwqTj
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/
