Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script Fails

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

6 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Can you post that applymap line?

Celambarasan

Not applicable
Author

This is the apply map line.

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

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

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

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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