Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Big table with multiple fields

Hi

 

I have a big table (about 8 millions records), and this table has 10 fiels that indicate if a customer has or not a specific product. This is an Example:

 

Table1:

HasProductA | HasProductB | HasProductC  | HasProductD | HasProductE...

         yes        |      no            |       no             |        yes          |         no...

 

 

I would like to have a Slicer with all the products, so users are able to select one or more products. Currently, I have multiple slicers that looks awful.

I think that that will be possible only if I have all this fields combined into one... but How should I do that?

Thanks

Thanks

Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    If you want to have this in once slicer, the relevant column names must become values in a column.

    To achieve this you must unpivot them. 

    Then delete the rows with  "no" .

4 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Community Champion
    6 years ago

    Hi Anonymous , 

    Do you also have a products table? We will need to see more. If you do, are the customers and products table related?

     

    Thanks,

    Nathaniel

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Nathaniel

       

      No, I don't have a product table. I have a big table that is denormalized, i.e Products are in the same table that customers.

      Should I try to normalize it? Or it may be dangerous?

       

      Thanks

      • Nathaniel_C's avatar
        Nathaniel_C
        Community Champion
        6 years ago

        Anonymous ,

         

        Lets reach out to ImkeF . She is a wiz!

         


        Let me know if you have any questions.

        If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
        Nathaniel