Forum Discussion
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...
Glad to hear that. You may help accept the solution above. Your contribution is highly appreciated.
I haven't accepted a solution because there wasn't a solution given. I understand PattemManohar has been very helpful, but that wasn't the soloution as I already know how to pivot the table how I wanted it, My problem was the data wasn't loading with the pivoted columns, so it would be wrong for me to say that was the soloution when it wasn't and save people from trying it. But for PattemManohar great help, i have given PattemManohar a tick for thanks.
I hope you understand my reasons for not accepting a solution.
My solution was to reload the data from scratch and it worked.