Or (assuming MonthNum contains a number such as 8 for Aug
Month(MakeDate(2000, MonthNum, 1)) As Month
FOR i=1 to 12
LOAD Month(MakeDate(Year(Today()),$(i),1)) as Month AutoGenerate(1);
FOR i=1 to 31
LOAD $(i) as Day AutoGenerate(1);
You can also concatenate the Month or Day field with your original table month & day fileds. By using Concatenate(Table1) Load ...
In your QV script, you can set your Month Names like this...
based on which, you can call them in your script below as ... Month(xyz) as "Month Name"
In your fact table or where you have field MonthNum use Mapping table and map the Monthname in the table See the load script
Mapping LOAD * INLINE [
LOAD *, ApplyMap('MapTable',MonthNum) as MonthName Inline [
*, ApplyMap('MapTable',MonthNum) as MonName
Try like this
Pick(MonthNumber, 'Jan', 'Feb', 'Mar', 'Apr', 'May','Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec') AS MonthName
After load a table as mapping table then if you have problem to get the correct monthname then try to load your map table differently see the load script
RowNo() as MonthNum,
Month(AddMonths((Today()),RowNo()+7)) as MonName
LOAD *, ApplyMap('MapTable',MonthNum) as MonthName