Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago

adding additional columns after making copies to a query table

I have a main table which I created a copy of and then unpivoted some columns.

After I've done this action, I have gone back and added an index column in the main table, but I'm not seeing the values populate in the copied table. How can I get this to show up?

Need Help

4 Replies

  • ImkeF's avatar
    ImkeF
    Community Champion
    6 years ago

    Hi jcastr02 

    check the generated M-code: Does it use "Unpivot.OtherColumns"? Then you have to add the new index columns into the list of the columns names specified there.

     

    • jcastr02's avatar
      jcastr02
      Post Prodigy
      6 years ago

      ImkeF I tried that, but then when I refreshed it stated it can't find that column name.  It was added as a index column in query editor, it is not coming from my source, not sure if that makes a diff. or not?

      • ImkeF's avatar
        ImkeF
        Community Champion
        6 years ago

         

        This should absolutely make no difference. Check the spelling. PQ is case sensitive.

         

  • Jimmy801's avatar
    Jimmy801
    Community Champion
    6 years ago

    Hello jcastr02 

     

    when you copied the table, did you reference another query or copy the query?

    I think you just copied the query, and therefore not copied / referenced.

    The solution to this would be to create a reference to your original table/query.


    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy