Forum Discussion
Merging two big files
Good day all I am trying to pick one column from another table basis certain conditions met and getting error message Expression: Error: Evaluation ran out of memory and can't continue . My...
It's not space that's the problem, it's addressable memory (RAM).
Have a go with stripping back the table columns/rows before the merge and see how you get on.
Let me know if you're still struggling as there may be other options available utilising the Excel Data Model.
Pete
Hi Pete
Getting same error message when I tried to group by for just 6 columns....
It seems some problem with particular column.
Regards
Mohit