Inline months

[everest226]

I have a table AAA source which has field  month as JN, Fb, MR , how do i load inline to show January , February and linked to that field  

[Bill_Britt]

HI,

You can add an inline table

LOAD * INLINE [
AAA, Months
JN, January
FB, February
MR, March
];

Bill

[Vegar]

 I support @Bill_Britt  proposal using an inline, but I would probably create the Month value as an dual() to assure a better sort order of the field in my application.

Months:
LOAD 
   AAA,  
   DUAL(Month, No) as Month
INLINE [
   AAA, Month, No
   JN, January, 1
   FB, February,2
   MR, March,3
   AP, April, 4
   ...
];