mapping load using proceeding load

[Anonymous]

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 ...

[maxgro · Accepted solution]

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(..........),

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

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

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

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

from

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

[Anonymous]

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

[maxgro]

maybe a previous crash of qlikview

close qlikview

try to delete the qvd

reload with the store