Forum Discussion
My Table Pivot isn't working
I have a table with an index column [Index] as a unique identifier, an [Attribute] column which holds whether the [Result] is the category name or category result (the only two values in this column are 'Cat' and 'Result'), a [Value] column which holds either the category name or category result.
In order to split [Attribute] into two columns called [Category] and [Result] I have added a second index [Index1] starting from 0 and then performed the following query:
= Table.Pivot(Index, List.Distinct(Index1[Attribute]), "Attribute", "Value", List.Min)But it's telling me that the name 'Index1' isnt recognised. Am I doing something wrong?
4 Replies
- HotChilli
Community Champion
Did you write the line yourself or use the interface to produce it?
HotChilli I wrote it myself, someone gave it to me and it worked before I had another Index column as a unique identifier. Now, it seems upset that I changed it to Index1
- HotChilli
Suggest using the interface ( from Transform menu) to do the pivot.
The code is passing the wrong parameters - Index1[Attribute] is not a list, Index is probably not a table.
At least try to do the Pivot from the interface and compare / contrast with the code written.
