Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

How to stop QV load those field value start with Charater ?

Hi All

May i know , it there any way i can add some more command into my below script ?

in order for QV not to read those Part Number which start with charater , A to Z .

Paul

1 Solution

Accepted Solutions
Not applicable

Re: How to stop QV load those field value start with Charater ?

Hi Paul,

I have re-attached your example and I believe it works as you require it to. I have added a where clause to your load script as below:

Where isNum(Left(PART_NO_,1));

tresesco is right and you need to use a where clause after your from statement to limit the data that you load into your final model.

Hope that helps,

Andy

5 Replies
MVP
MVP

Re: How to stop QV load those field value start with Charater ?

Try putting some condition like this:

Load *

From <> Where IsNum(Left(Trim(PART_NO_) ,1)) ;

Not applicable

Re: How to stop QV load those field value start with Charater ?

Hi Tres

since i am trying to load only 1 file which having problem , i try not to use where . so i try


IsNum(Left(Trim(PART_NO_) ,1)) ;


i get syntax error , can you pls tell me how to aviod syntax error .


By the way for my case the part number is start with number follow by charater.


Paul

MVP
MVP

Re: How to stop QV load those field value start with Charater ?

Then where are you trying to use that? You can use the same for similar files even if they don't have that kind of(error) data.

Not applicable

Re: How to stop QV load those field value start with Charater ?

Hi Paul,

I have re-attached your example and I believe it works as you require it to. I have added a where clause to your load script as below:

Where isNum(Left(PART_NO_,1));

tresesco is right and you need to use a where clause after your from statement to limit the data that you load into your final model.

Hope that helps,

Andy

Not applicable

Re: How to stop QV load those field value start with Charater ?

Hi Andrew

Many thank for your attachment , now i understand where to place the :-

Where isNum(Left(PART_NO_,1));

I place at wrong location , because first time i use where command.

Paul

Community Browser