Forum Discussion

eldarkt's avatar
eldarkt
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
Solved

Filter by multiple sets of column

Hi all, I have a data set like this:   Customer1_value1 Customer1_value2 … Customer1_value15 Customer2_value1 … Customer2_value15 … CustomerN_value1 … CustomerN_value15 0.229151652 ...
  • sdjensen's avatar
    sdjensen
    9 years ago

    Hi eldarkt,

     

    This approach should do the trick

    1. select the column 'Attribute.2'

    2. Select 'Pivot Column' on the Transform tab

    3. In the pop-up select 'Value' as Values Column

sdjensen's avatar
sdjensen
Icon for Solution Sage rankSolution Sage
9 years ago

Hi eldarkt,

 

This approach should do the trick

1. select the column 'Attribute.2'

2. Select 'Pivot Column' on the Transform tab

3. In the pop-up select 'Value' as Values Column

eldarkt's avatar
eldarkt
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

 

Many thanks, sdjensen, it works!

My mistake when I tried pivot was I didn't turn off aggregation here (it was "count(all)" by default) :


and it showed "1" in each field instead of source values.
I changed it to "Don't Aggregate" and it did the trick.
What a wonderful forum it is! :smileyhappy: