Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Split rows by interval in M query

Hi, I have two tables: -Account scheduled Schedule_Name Line_No Row_No Totaling Totaling_Type New_Page Indentation BALANSAS P 750000 E.I.1.3 '4013'|4014 Registravimo sąskaitos FAL...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

I don't understand how to get the numbers below in total column

27110 27111 27112 27113

27120 27121

2713 27130

There is no such number in Account table.

 

Best Regards
Maggie

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi, v-juanli-msft , thanks, for replay,

    There are those accounts in the Account table...

    27110Sąskaita SEB Eur
    27111Sąskaita SEB kita valiuta
    27112Sąskaita SEB VISA
    27113Sąskaita SEB MasterCard
    27120Sąskaita DNB Eur
    27121Sąskaita DNB kita
    2713Sąskaita AS DNB Pank EESTI Filial
    27130Sąskaita AS DNB Pank EESTI Filial

     

    But I think that this case is a bit confusing, let's make it easier to understand

     

    We have a table with a list of numbers, from 1 to 20

    No.
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20

    And another table where is two columns: case and interval

    CaseInterval
    Case11..3
    Case25..12
    Case37..10

     

    How do I get split rows by interval, like this with M language:

    CaseInterval
    Case11
    Case12
    Case13
    Case25
    Case26
    Case27
    Case28
    Case29
    Case210
    Case211
    Case212
    Case37
    Case38
    Case39
    Case310