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...
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" .

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

      • ImkeF's avatar
        ImkeF
        Community Champion
        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" .