Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Grouping

Hi,  My FACT TABLE has got a column 'Card Number', 4 'Card numbers' that are already grouped are: 'Remote start', 'gf-webpay', 'vc-WebPay' and 'Engineer'.  The issue is with million of the ones ...
Show and Tell
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you amitchandak, 
    I am afraid the solution will not help my problem.
    I must group items from within one column only. 
    Within the column there are 3 groups there already. 
    The column is million rows long. 

    In my column: 'Card number'

    It has got millions of various CC numbers:

    CC-002

    CC-00024

    CC-00089787

    ...etc. All these various CC numbers need to be grouped together.

     

    Next Group:

    Webpay1

    Webpay2

    VCWebpay

    These three also need to be grouped.


    Last but not least I have millions of rows in that column that are all very different. These are members number, e.g.:

    CP678

    B89789

    EC-uiu-UK

    KM8987ND7

    How do I approach this please? 

    Thank you, 

    J