Forum Discussion

sidneyjacobs's avatar
sidneyjacobs
Frequent Visitor
4 years ago
Solved

GROUP BY in PowerQuery ignores 1 specific value

Hey everybody, I'm either missing something extremely obvious, or I've come across a bug in PowerQuery.   I'm creating a table of clients, their orders and the products in those orders. While tryi...
Need Help
  • sidneyjacobs's avatar
    sidneyjacobs
    4 years ago

    Dear Kelly,

     

    I'm still not quite sure why.. but after a few database loads and recreating the steps my problem went away. I guess I'm better off removing the topic since I can't reproduce the steps and pose a solution for other community members.
    Thank you for reaching out though!

    Sidney

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I bet it's an escape character issue, with # being an escape.  Before grouping, try using the Replave Values function on the Client Number column, and replace # with ~ and then group.

 

--Nate

  • sidneyjacobs's avatar
    sidneyjacobs
    Frequent Visitor
    4 years ago

    Hello Nate,

    That's a good suggestion. I was a little unclear however: I used # to replace the actual value (think A0505483249) This is a mix of letters and numbers, never containing an escape character.

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      4 years ago

      Hi  sidneyjacobs ,

       

      Could you pls paste some screenshots to let us check whether there is some missing details?

      Remember to remove the confidential information.

       

      Best Regards,
      Kelly

      Did I answer your question? Mark my raeply as a solution!

      • sidneyjacobs's avatar
        sidneyjacobs
        Frequent Visitor
        4 years ago

        Dear Kelly,

         

        I'm still not quite sure why.. but after a few database loads and recreating the steps my problem went away. I guess I'm better off removing the topic since I can't reproduce the steps and pose a solution for other community members.
        Thank you for reaching out though!

        Sidney