12.9 Associate multiple rows of data
Here below is a data table:
The task is to associate the bid and cid of Sheet1 with the corresponding bid and cid of Sheet2, and calculate the values of aid in Sheet2. Enter the formula in cell C2:
| A | |
|---|---|
| 1 | =E(‘Sheet1!A$1:C$15’).group(bid,cid;~.(aid):aid) |
| 2 | =E(‘A1:B6’) |
| 3 | =A1.align(A2:[bid,cid],[bid,cid]) |
| 4 | =A3.(aid) |
A1: Convert the data of Sheet1 to a table sequence, and then group by bid and cid, with multiple aids under each group
A3: Associate the bid and cid of Sheet1 with the corresponding bid and cid of Sheet2
A4: Return the aids in the result
esProc Desktop and Excel Processing
12.8 Use interval range to perform retroactive searching of association table
12.10 Associate with detail table
SPL Official Website 👉 http://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/
SPL Learning Material 👉 http://c.scudata.com
Discord 👉 https://discord.gg/ydhVnFH9
Youtube 👉 https://www.youtube.com/@esProcDesktop
Linkedin Group 👉 https://www.linkedin.com/groups/14419406/
