Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How can I bring back the table I had before I grouped two columns?

I want to see the original table and the new columns that got grouped. I'll appreciate the help, thank you.

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Just the name of the table(Step name), which is equal to the name of the query from which the table is the result.

     

    If the name of the query (table) contains spaces or other special characters, the name must be included in #"....",
    e.g. #"Table name".

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    That table can always be referred to by its step name, like

     

    = TheStepNameBeforeTheGroupStep

     

    or like

     

    = Table.Join(PriorStep, {"Column"}, StepNameBeforeTheGroup, {"Column"}, JoinKind.Whatever)

     

    --Nate

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    Just the name of the table(Step name), which is equal to the name of the query from which the table is the result.

     

    If the name of the query (table) contains spaces or other special characters, the name must be included in #"....",
    e.g. #"Table name".

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.