Forum Discussion

tomshaw83's avatar
tomshaw83
Helper I
5 years ago
Solved

Cleaning Data

Hi,   I am looking to reshape some messy data from a PDF table as in the example below, to create the table below that.   I can perform this transition (i think) with many, many, many applied ste...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi tomshaw83 

    I'm not sure if my solution is more efficient than yours. But my solution is all processed with the user interface without needing to modify the M codes in Advanced editor. You can download the attached pbix file to check specific steps.

     

    To make it clearer, I deal with the data in separate queries and combine them at the end. 

    Hope this helps.

    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Hi tomshaw83 

I'm not sure if my solution is more efficient than yours. But my solution is all processed with the user interface without needing to modify the M codes in Advanced editor. You can download the attached pbix file to check specific steps.

 

To make it clearer, I deal with the data in separate queries and combine them at the end. 

Hope this helps.

Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.