topic Script Fails in QlikView

Script Fails

Wed, 25 Apr 2012 17:26:15 GMT

I have a script that loads a table and then stores it. All was working until I added a line that applies a mapping (ApplyMap). If I don't store that table the script runs fine. As soon as I add the line to store the table the script fails. Why?

Thanks,

Stephen

Script Fails

CELAMBARASAN — Wed, 25 Apr 2012 18:34:06 GMT

Hi,

Can you post that applymap line?

Celambarasan

Script Fails

Wed, 25 Apr 2012 18:42:13 GMT

This is the apply map line.

ApplyMap('CodeList',VBTYP_N) as VBFA_I.CodeDesc_VBTYP_N,

Script Fails

jonathandienst — Wed, 25 Apr 2012 19:58:00 GMT

If you comment out the store statement does the script run OK, and is the mapping working the way you expected?

Regards

Jonathan

Script Fails

Wed, 25 Apr 2012 20:03:39 GMT

Yes the mapping runs fine and is correct. It only fails when I put in to Store code and the Store code works when I comment out the ApplyMap code.

Stephen

Script Fails

jonathandienst — Wed, 25 Apr 2012 20:11:57 GMT

Stephen

Does it fail for both types of store (txt and qvd)?

I would check the contents of the mapping table as well. It sounds like something weird is happening when you use the mapping.

Can you post an example?

Jonathan

Script Fails

Wed, 25 Apr 2012 21:40:19 GMT

Solved. The the table that gets created (recreated) was locked, thus the script failed.