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