Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

5 Replies
tresesco
MVP
MVP

Try putting some condition like this:

Load *

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

Not applicable
Author

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

tresesco
MVP
MVP

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
Author

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
Author

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