Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI,
You can add an inline table
LOAD * INLINE [
AAA, Months
JN, January
FB, February
MR, March
];
Bill
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
...
];