Forum Discussion
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...
Without further clarification and sample data I can only guess...
- Take you 100K table
- Do a group by on all columns except the insight attribute columns
- selecting 'keep all rows'
- Name the aggregate column [Attribute Rows]
- Add an new column with the following formula
- = Table.AddColumn(#"Grouped Rows", "Attributes", each Text.Combine([Attribute Rows][INSIGHT_ATTRIBUTE_NAME], "|"))
Combine in the same cell based on other field (server name, object key... i have a few fields which can be used for this) separataed by a ||
If you want us to help you, it is mandantory to privide sample data in usable format (if yo don't know how - read note below my post) and expected result based on sample data (at least screenshot)
