"E xample There is an Excel file Book1.xlsx, and part of the data is as follows: aid bid cid XD19 .."

Hoo RaqForum 19 No.
1 Reply • 393 View • 3 Years ago

Associate multiple rows of data

Example

There is an Excel file Book1.xlsx, and part of the data is as follows:

There is an Excel file Book2.xlsx, the data is as follows:

The bid and cid of Book1 are correspondingly related to the bid and cid of Book2. Find the aid for each group. Part of the results are as follows:

Write SPL script:

	A
1	=file("Book1.xlsx").xlsimport@t()
2	=file("Book2.xlsx").xlsimport@t()
3	=A1.group(bid,cid;~.(aid):aid)
4	=A3.align(A2:[bid,cid],[bid,cid])
5	=A4.(bid\|cid\|aid)
6	=file("result.xlsx").xlsexport@w(A5)

A1 Read excel file

A2 Read excel file

A3 Group Book1 according to bid and cid, and each group has multiple aids

A4 The bid and cid of Book1 are associated with the corresponding relationship of Book2

A5 Combine the bid, cid, and aid columns

A6 Export the result to result.xlsx

SPL Official Website 👉 https://www.scudata.com

SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_Desktop/

SPL Learning Material 👉 https://c.scudata.com

Discord 👉 https://discord.gg/cFTcUNs7

Youtube 👉 https://www.youtube.com/@esProcDesktop

Linkedin Group 👉 https://www.linkedin.com/groups/14419406/

Desktop

Hoo • 393 View • 3 Years ago