3.24 Find difference between table sequences through MERGE
Find the number of different rows in two same-structure data files.
| ID | Predicted_Y | Original_Y |
|---|---|---|
| 10 | 0.012388464367608093 | 0.0 |
| 11 | 0.01519899123978988 | 0.0 |
| 13 | 0.0007920238885061248 | 0.0 |
| 19 | 0.0012656367468159102 | 0.0 |
| 21 | 0.009460545997473379 | 0.0 |
| 23 | 0.024176791871681664 | 0.0 |
| … | … | … |
| A | |
|---|---|
| 1 | =T(“p1.xlsx”) |
| 2 | =T(“p2.xlsx”) |
| 3 | =[A1,A2].merge@x() |
| 4 | =A3.len() |
A1 Retrieve the first sampling file.
A2 Retrieve the second sampling file.
A3 Use merge function to merge and compare all fields in order. @x option enables returning all different rows.
A4 Return the number of different rows.
Execution result:
| Value |
|---|
| 458 |
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProcSPL
SPL Learning Material 👉 https://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProc_SPL
