Forum Discussion
KH11NDR
Helper IV
7 years agoUnpivot 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
Community Champion
KH11NDR Please post the sample data to replicate your issue and also helpful to resolve the issue quicker...
- KH11NDR
Helper IV
Project ID 42917 42948 42979 43009 43040 43070 43101 43132 43160 43191 43221 1 0 0 0 0 0 9 63.5 63.5 53.5 70.5 76.5 2 28 39 51 57 50 43 46 34 5 0 0 - PattemManohar
Community Champion
KH11NDR Thanks for that... What is your expected ouput, please...