Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In my data model qvf, it contains all the inline mapping load tables. However, in my application app, I realised that my applymap() script do not get loaded in my application app after I use binary load.
Is there any way to do this?
Much help is appreciated. Thank you so much.
Thank you very much! I have one last problem with my data. Lets say I created a new table to store as below.
N_STDNT_TERM_CV:
LEFT KEEP (ACAD_PROG) LOAD
EMPLID ,
ACAD_CAREER ,
STRM ,
Num((CUR_GPA),'##.00') as CUR_GPA,
Num((CUM_GPA),'##.00') as CUM_GPA
FROM xxx;
MAX_STRM:
LOAD EMPLID ,ACAD_CAREER,INSTITUTION,MAX(STRM) as STRM1 RESIDENT N_STDNT_TERM_CV
where NOT ISNULL(CUM_GPA) group by EMPLID,ACAD_CAREER,INSTITUTION;
JOIN(MAX_STRM)
LOAD EMPLID,ACAD_CAREER,INSTITUTION,ADMIT_TERM RESIDENT ACAD_PROG WHERE EXISTS (ADMIT_TERM);
LATEST_STRM_GPA:
LOAD EMPLID,ACAD_CAREER,INSTITUTION,STRM1,
'20'&left(STRM1,2) as STRM_YEAR RESIDENT MAX_STRM where not match(STRM1,ADMIT_TERM);
LEFT JOIN (LATEST_STRM_GPA)
LOAD EMPLID ,ACAD_CAREER,INSTITUTION,STRM as STRM1,CUM_GPA as CUM_GPA_LAST
RESIDENT N_STDNT_TERM_CV
where exists(EMPLID)and exists(STRM);
drop table N_STDNT_TERM_CV;
drop table MAX_STRM;
I am creating a new table to store EMPLIDs with a max(STRM) GPA, basically I am getting the latest GPA of an EMPLID grouped by the ACAD_CAREER. But I realised that after I binary loaded App1, the data is not recognized. Any thoughts about this behaviour?