Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have following script, I have created mapping table to map M_STATUS against SYSTEM field from Table2 but i am not able to map it.
Please let me know if their is any wrong with script.
M_STATUS:
Mapping
Load 'AB' as SYSTEM
M_STATUS
FROM Table1;
DATAMODEL:
Load *, Applymap('M_STATUS',SYSTEM,null()) as STATUS;
Load VENDOR,
PO_ORDER,
'AB' as SYSTEM
FROM Table2;
Thanks,
Villyee.
Well, probably his M_STATUS is Null(), who knows
Yes, I think that is the case. Most probably first record of M_STATUS is null