Forum Discussion

divumj's avatar
divumj
Icon for Helper I rankHelper I
2 years ago

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...
General Comment
divumj's avatar
divumj
Icon for Helper I rankHelper I
2 years ago

Hi Pete

 

Thanks for the response I am doing it on Excel 365 and in official environment so space shouldn't be the issue...but still I can check if I can reduce the size of columns..

 

My Ram size is 8GB and OS is 64 bit

 

Regards

Mohit Jain 

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
2 years ago

 

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

  • divumj's avatar
    divumj
    Icon for Helper I rankHelper I
    2 years ago

    Hi Pete 

     

    Columns are not more it was around 40, still I have identified few without which we can still go.

     

    But getting same error during group by...am I doing something wrong...

     

    Regards

    Mohit 

  • divumj's avatar
    divumj
    Icon for Helper I rankHelper I
    2 years ago

    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