I am searching a way to unpivot all my columns execpt the first one. Because the source files will grown in the future with other columns.
So, i try to find a way to unpivot all the columns (except the first one) without naming each columns.
I search in the Data Explorer Formula Language Specification without success.
Does someone have an idea ?
You can replace the hard coded columns list in the formula with:
So it'll look something like this:
= Table.Unpivot(Source,List.Skip(Table.ColumnNames(Source), 1),"Attribute","Value")
Peter Q. http://blogs.msdn.com/peter_qian
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?