There are sporadic mentions of PARTITION BY used in ETL Services Input Queries, right after the ORDER BY statement. I have been unable to figure out what that exactly does. There is a snippet of documentation at:
https://docs.infor.com/birst/2024.x/en-us/birstdataandmodels/Data/TransformETL/ETL_Services_Overview.html?Highlight=PARTITION
By browsing through the old communities, I found a couple of mentions, most notably this one:
https://community.infor.com/infor-birst/f/admin---administration-user-management/36228/cross-apply-in-scripted-source/95099#95099
All of this is related to a need that I have to do some windowing, alike T-SQL's OVER (PARTITION BY …). I have also found:
https://community.infor.com/infor-birst/b/legacy-blog-posts/posts/how-to-build-this-functionality-in-birst
which mentions the following URL:
https://community.birst.com/thread/8912
This is dead and I found no archive over the Internet. Does Infor have any copy of old Birst forums?