Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try putting some condition like this:
Load *
From <> Where IsNum(Left(Trim(PART_NO_) ,1)) ;
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
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.
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
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