topic Re: mapping load using proceeding load in QlikView

mapping load using proceeding load

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am updating 5 columns by CMS using proceeding load. But get a general script error at the last step, according to the log file. Can anyone help to see anything wrong with the script?

Mgr:

Mapping

LOAD CMS,

fvc_rep_mgr2

FROM...

Rep:

Mapping

LOAD CMS,

fvc_rep2

FROM...

Practice:

mapping

LOAD CMS,

fkc_practice_name2

FROM...

Physician:

mapping

LOAD CMS,

fkc_attending_name2

FROM...

Facility:

mapping

LOAD CMS,

fkc_facility_name2

FROM ...

CombinedDataNSM:

LOAD*, applymap('Rep', fvc_rep_mgr, fvc_rep_mgr) as fvc_rep_mgr2;

LOAD*, applymap('Rep', fvc_rep, fvc_rep) as fvc_rep2;

LOAD*, applymap('Practice',fkc_practice_name,fkc_practice_name) as fkc_practice_name2;

LOAD*, applymap('Physician',fkc_attending_name,fkc_attending_name) as fkc_attending_name2;

LOAD *,applyMap('Facility', fkc_facility_name, fkc_facility_name) as fkc_facility_name2

FROM ...

Store CombinedDataNSM into ...

Re: mapping load using proceeding load

maxgro — Wed, 08 Mar 2017 19:19:24 GMT

Try to comment the store

Sometimes the "general script error" happens in a qvd store

Also

it seems you don't need 4 or five preceding load

you can

LOAD

appymap(..........),

from

............l

Re: mapping load using proceeding load

Anonymous — Wed, 08 Mar 2017 19:23:28 GMT

It works. But I do need store the file to export to another application. Any suggestions?

Re: mapping load using proceeding load

maxgro — Wed, 08 Mar 2017 19:33:47 GMT

maybe a previous crash of qlikview

close qlikview

try to delete the qvd

reload with the store