topic Inline months in App Development

Inline months

everest226 — Mon, 20 May 2019 18:55:39 GMT

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

Re: Inline months

Bill_Britt — Mon, 20 May 2019 19:12:09 GMT

HI,

You can add an inline table

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

Bill

Re: Inline months

Vegar — Mon, 20 May 2019 19:33:12 GMT

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 ... ];