I have a grid which will have around 50k - 1Lakh records. And I need to filter the record with status as failure and send those rows in a single email.
Note: The grid is spying n windows mode.
My Appraoch: 1) I tried capturing the table and read the values using "Read Table". But Blue Prism got hanged due to high volume of data. (Failed)
2) Gave SHIFT + CTRL + END and copied values to clipboard and split using "Split By Line" under "String" VBO (Failed)
Please help me in advising on what approach to follow to deal with Data manipulation with huge volume of records.
