Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
You need a following load to your crosstable-load which creates an appropriate month-field because values like '1/19' won't match with 'Jan' from the month() function. For this you could use something like this:
...
ForecastFinal:
load *, month(makedate(subfield(Month, '/', 2), subfield(Month, '/', 1)) as MonthNew resident Forecast;
...
- Marcus