Hi,
it's so inefficient to manipulate such a large data in collection (DataTable),
so if I were you I created temporary table in access or SQL Server, and execute SQL query to them.
To use them, you could use "Data - OLEDB" VBO.
For more information, see the document below:
https://portal.blueprism.com/system/files/2017-09/Blue%20Prism%20-%20Guide%20to%20OLEDB%20v2.pdf------------------------------
Kota Suto
Japan
------------------------------