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...
All my data is like this:
I have +100k rows with the values in rows instead of columns.
So in order to get it "correctly" i group the data bye INSIGHT_ATTRIBUTE_NAME, then add an Index Column and then pivot it so i get a colum for each of these values.
But as for columns with more than one value (like CPUs, Disk and Network Interfaces) it creates a lot of rows for these (some servers have 10 network interfaces, 32 CPUs, and 15 Disks):
Just like this, CPUs, Network Interfaces and Disks columns have hundreds of values surround but everything else "null".
