Forum Discussion

mcflurry's avatar
mcflurry
Helper I
2 years ago

Pivoted table with multiple values on one column

I'm facing a problem pivoting a table. I have issues with 3 columns (after pivoting) which fields have more than one value. The problem is that these columns have hundreds of fields with their righ...
Need Help
dufoq3's avatar
dufoq3
Community Champion
2 years ago

Hi mcflurry, could you provide expected result based on this data please?

 

Keezz's avatar
Keezz
Helper I
2 years ago

Without further clarification and sample data I can only guess...

  1. Take you 100K table
  2. Do a group by on all columns except the insight attribute columns
    • selecting 'keep all rows'
    • Name the aggregate  column [Attribute Rows]
  3. Add an new column with the following formula
    • = Table.AddColumn(#"Grouped Rows", "Attributes", each Text.Combine([Attribute Rows][INSIGHT_ATTRIBUTE_NAME], "|"))