?

xyz1 — Sun, 14 Apr 2019 16:52:27 GMT

Re: Concatenate cross table with field name as "month name"

marcus_sommer — Thu, 10 Jan 2019 08:09:00 GMT

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

topic ? in App Development

?

Re: Concatenate cross table with field name as "month name"