Forum Discussion

jcastr02's avatar
jcastr02
Icon for Post Prodigy rankPost 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 value...
Need Help
ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity 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
Icon for Post Prodigy rankPost 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
    Icon for Community Champion rankCommunity Champion
    6 years ago

     

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