Forum Discussion
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...
v-juanli-msft
Community Support
Community SupportHi 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
Hi, v-juanli-msft , thanks, for replay,
There are those accounts in the Account table...
| 27110 | Sąskaita SEB Eur |
| 27111 | Sąskaita SEB kita valiuta |
| 27112 | Sąskaita SEB VISA |
| 27113 | Sąskaita SEB MasterCard |
| 27120 | Sąskaita DNB Eur |
| 27121 | Sąskaita DNB kita |
| 2713 | Sąskaita AS DNB Pank EESTI Filial |
| 27130 | Są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
| Case | Interval |
| Case1 | 1..3 |
| Case2 | 5..12 |
| Case3 | 7..10 |
How do I get split rows by interval, like this with M language:
| Case | Interval |
| Case1 | 1 |
| Case1 | 2 |
| Case1 | 3 |
| Case2 | 5 |
| Case2 | 6 |
| Case2 | 7 |
| Case2 | 8 |
| Case2 | 9 |
| Case2 | 10 |
| Case2 | 11 |
| Case2 | 12 |
| Case3 | 7 |
| Case3 | 8 |
| Case3 | 9 |
| Case3 | 10 |