Discussion Board for collaboration related to QlikView Deployment.
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 .
Go to Solution.
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:
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,
Try putting some condition like this:
From <> Where IsNum(Left(Trim(PART_NO_) ,1)) ;
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.
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.
Many thank for your attachment , now i understand where to place the :-
I place at wrong location , because first time i use where command.