Forum Discussion
Table.Pivot - Pivoted Column - dealing with duplicates
At step4) - "4) generalize the [Attribute] column into values containing either "Location" or "Count".",
if you split the column from non-digit to digit and leave both columns in place, you can do the Pivot with "Don't aggregate". There shouldn't be any errors at that point.
You can then sort out the datatypes, maybe remove columns and probably do a 'Group By' to get what you want
At step4) - "4) generalize the [Attribute] column into values containing either "Location" or "Count".",
if you split the column from non-digit to digit and leave both columns in place, you can do the Pivot with "Don't aggregate". There shouldn't be any errors at that point.
You can then sort out the datatypes, maybe remove columns and probably do a 'Group By' to get what you want
Hi, thanks for your response. Can you clarify a few things?
1) "if you split the column from non-digit to digit and leave both columns in place"
Does this mean end up with the same genralized Location or Count column, as well as a column for which set of columns (values being 1-8)?
2) "you can do the Pivot with "Don't aggregate""
Which column should I Pivot? The same Location/Count column?
I think i understand what you're getting at with the Group By, but I still cant get the Pivot to work
for anyone looking at this, I needed to Group By the digit column. That was confusing me but once i did that it worked for me.