Storing a table containing NULL value to a txt or qvd file fails with error General Script Error in statement handling
For example, the following piece of the script fails with the above error when executed:
DataTable:
LOAD * INLINE [
NP
1
];
LEFT JOIN
LOAD * INLINE [
NP, AD
2, test
];
STORE AD FROM DataTable INTO [lib://Temp/test.csv] (txt);
Environment:
Resolution:
- Verify if there are extra and unintended characters in any of the column names (blank spaces, extra letters). Remove them and run the script again. In addition, see IsNull - script and chart function which may help with troubleshooting.
- Verify that sufficient disk space is available.
- This issue was reproduced in lab only in the November 2018 releases and not on newer builds. There was no fix officially produced for the problem found on November 2018. Note that November 2018 is no longer a supported version, so upgrading to a newer release to check if issue is resolved would be required. See Qlik Sense, QlikView, NPrinting, Qlik Insight Bot End of Support Date
If you experience the issue in an up to date Sense environment, connect with our active Qlik Community for creative application development assistance and ideas.