Forum Discussion

maj's avatar
maj
Helper I
6 years ago

Grouping Data

Hello,   I have a very large dataset (26MM rows) that contains hundreds of customer names.  I want to group them as such:   If customer name is A, group A If customer name is B, group B If cust...
Need Help
maj's avatar
maj
Helper I
6 years ago

Hi Anonymous,

 

My data source is a dataflow that was created through a connection to an Azure Databricks table.  I created the table in Azure using SQL query.  Are you saying it's best to do the grouping in my query, which feeds the dataflow, which feeds my PBI report?

 

Thanks!

-maj

Anonymous's avatar
Anonymous
Not applicable
6 years ago

maj ,

 

Yes  it's best to do the grouping in  query, which feeds the dataflow, which feeds my PBI report.

 

Cheers

 

CheenuSing

  • maj's avatar
    maj
    Helper I
    6 years ago

    Anonymous 

     

    I'm not familiar with grouping.  Do you have any suggestion on how to write this in SQL?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi maj ,

       

      Please send me your current query and also share a set of 10000 records in excel . Upload the excel and query to OneDrive or Google Drive and share the link . Please alsso mention what is the result you expect on the sample data.

       

      Cheers

       

      CheenuSing