Forum Discussion

KH11NDR's avatar
KH11NDR
Icon for Helper IV rankHelper IV
7 years ago

Unpivot only selected columns not working

Hi Guys,

 

I'm editing a query (table) which I've loded in from SQL and it allows me to Unpivot only selected columns and I'll rename the two columns as date and values.  But when i press close and apply, it doesn't apply the changes and says "The column 'first column' of the table wasn't found".

 

I have no problem in doing the same thing with data loaded in from excel.

 

Thanks guys.

9 Replies

  • PattemManohar's avatar
    PattemManohar
    Icon for Community Champion rankCommunity Champion

    KH11NDR Please post the sample data to replicate your issue and also helpful to resolve the issue quicker...

    • KH11NDR's avatar
      KH11NDR
      Icon for Helper IV rankHelper IV

      PattemManohar

       

      Project ID4291742948429794300943040430704310143132431604319143221
      100000963.563.553.570.576.5
      22839515750434634500