Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
NewToQlik
Creator
Creator

Inline mapping load before binary load?

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.

Labels (2)
10 Replies
NewToQlik
Creator
Creator
Author

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?