topic Re: Star is * and Load Failure in QlikView

Star is * and Load Failure

kashjaniqlik — Thu, 01 Jun 2017 14:01:30 GMT

Hello

I'm using Star is * as the first statement in my QVW to load a set of user accounts in the section access file.

I also have a mapping load statement in my QVW to load two fields in to load table. One of the fields has * as one of the values.

The QVW load fails with a general script error which is very odd. The section access file maps a field in the file to a different data field in the data model (different from the field in the mapping load) so I'm not sure what is causing the QVW load to fail.

Many Thanks for any help.

Re: Star is * and Load Failure

vinieme12 — Thu, 01 Jun 2017 14:06:11 GMT

can you post the script!! not sure what statement you are using

Re: Star is * and Load Failure

prieper — Thu, 01 Jun 2017 14:06:20 GMT

Can you please post an example?

Re: Star is * and Load Failure

kashjaniqlik — Thu, 01 Jun 2017 14:12:23 GMT

Below is the screenshot. In this example, AccountNumber has * in one of the rows.

The error is "General Script Error" in the middle of Mapping Load.

Re: Star is * and Load Failure

prieper — Thu, 01 Jun 2017 14:27:38 GMT

What is the background for the STAR IS ... command?

Did you try to mask the loading of the "*", with

REPLACE(AccountNumber, '*', '|')?

Re: Star is * and Load Failure

kashjaniqlik — Thu, 01 Jun 2017 17:11:58 GMT

Masking the data has certainly help resolving the conflict with section access "Star is *" code.