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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

divumj  - so BA_Pete is right that memory limitation Power Query will hold you back, but if you can eloborate on the requirement "pick one column from another table based on certain conditions" by showing a sample of the data and your M code.  It is possible that the Table.Group will help, but you may need to add Table.Buffer step to stop Power Query from re-generating the Table.Group step.

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

    Hi Anonymous 

     

    Thanks for suggestions, I am doing group by from transformation tab which I think is similar to Table.group correct me if I am wrong.

     

    Table 1 - previous month data

     

    Column A Column B Column C

     

    Table 2 - current month data

     

    Column A Column B Column C

     

    I am trying, in case column B is blank than pull value from previous month if columns C data matches.

     

    For this I have tried merging option also I tried creating M query.

     

    Regards

    Mohit Jain