How to group using last 2 characters and subset the latest data?Hi all,
Is it possible to make a column for groupings using the last two characters from another column? For example, I have this table:
| LIVE | Groupings |
| FY24W38 | 1 |
| FY24W38 | 1 |
| FY24W39 | 2 |
| FY24W39 | 2 |
| FY24W39 | 2 |
| FY24W40 | 3 |
| FY24W41 | 4 |
| FY24W41 | 4 |
Is it also possible to subset the first 2 latest date according to the grouping? In this example, FY24W40 and FY24W41 will be selected then subset since they are the "latest" data. TIA
Automation and Scripting
