Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I'm new here and this is my first question.
Im trying to get a moving MAX value for the colummn MENGE which should change, when the text value on the colummn ARTNR also changes. I'm looking for the MAX MENGE value for each article and this value should be displayed and repeated for all the rows with the same ARTNR.
Here you have the structure of my data. It ´d be very glad if you could help me.
Thank you very much
Urdru.
ARTNR | LHMNR | SEKTORNR | MENGE |
- | |||
000.3-60-0000.5-L | 43017 | 2 | 3 |
000.3-60-0000.5-L | 43030 | 2 | 9 |
000.3-60-0002.0-L | 41699 | 1 | 3 |
000.3-60-0003.0-L | 42092 | 2 | 1 |
000.8-42-2-R | 42646 | 2 | 6 |
000.8-42-8-L | 42724 | 1 | 3 |
000.8-42-10-L | 43016 | 2 | 15 |
000.8-42-10-R | 42591 | 1 | 7 |
000.8-42-16-R | 42325 | 1 | 5 |
000.8-42-24-R | 43064 | 2 | 5 |
000.8-42-40-L | 42634 | 2 | 16 |
000.8-42-40-R | 42608 | 2 | 1 |
000.8-42-50-R | 42839 | 1 | 2 |
000.8-42-72-R | 42965 | 2 | 3 |
000.8-42-100-L | 42605 | 2 | 16 |
000.8-60-4-L | 41835 | 1 | 8 |
000.8-60-6-L | 42107 | 2 | 3 |
000.8-60-8-R | 42280 | 2 | 10 |
000.8-60-10-L | 42782 | 2 | 11 |
000.8-60-16-R | 41997 | 3 | 3 |
000.8-60-24-L | 41813 | 4 | 1 |
Maybe adding to your script:
Left Join (YourTable) LOAD ARTNR, max(Menge) as MaxMenge resident YourTable group by ARTNR;
Maybe adding to your script:
Left Join (YourTable) LOAD ARTNR, max(Menge) as MaxMenge resident YourTable group by ARTNR;
Thank you very much swuehl for you quick and certain answer. It runs perfectly.
MfG
Urdru