topic Error im geeting while using in statement in Sql in QlikView

Error im geeting while using in statement in Sql

srinivasa1 — Thu, 03 Feb 2011 15:50:37 GMT

Pls can any one help me out to use in Statement in Sql i have script like bellow ie:

where

thx in adavance

ReviewStatus in ('N','R','RED','YELLOW') ;

Error im geeting while using in statement in Sql

Thu, 03 Feb 2011 16:24:28 GMT

Could you re-paste that in? What error are you getting?

ReviewStatus in ('N', 'R', 'RED', 'YELLOW') seems okay, but we need more info to determine the problem.

Error im geeting while using in statement in Sql

srinivasa1 — Fri, 04 Feb 2011 14:02:33 GMT

Hi NMiller.

thanks for your suggestion.sorry for dealy to reply. im lodaing filr form text file my load script as bellow.

Load

CustId,

CustName

FROM

HumanaNightly20110120.txt

(txt, codepage is 1252, embedded labels, delimiter is '|', msq)

where ReviewStatus in ('N' ,'R' ,'RED' )

Error im geeting while using in statement in Sql

maneshkhottcpl — Fri, 04 Feb 2011 14:05:50 GMT

Hi,

If this is not working then take a resident of the table and use the following script.

Load * resident Table where wildmatch(ReviewStatus,'N','R','RED','YELLOW')>0;

will work fine.

Error im geeting while using in statement in Sql

Anonymous — Fri, 04 Feb 2011 14:09:00 GMT

This is not a SQL statement. SQL statements start from SELECT, not from LOAD. What you have is the QlikView LOAD statement, and it does not use in(). You can use match instead:
where match(ReviewStatus,'N' ,'R' ,'RED')

Error im geeting while using in statement in Sql

srinivasa1 — Fri, 04 Feb 2011 14:13:43 GMT

Thx Manesh,

but i wanted use in statment while loading only .why i need to create once again resident table if it possible handle in same stament. is there any other way or any Sql Load i has to use.

thx

Error im geeting while using in statement in Sql

srinivasa1 — Fri, 04 Feb 2011 14:17:55 GMT

Thx Micchael.

I wll try this .

Error im geeting while using in statement in Sql

srinivasa1 — Fri, 04 Feb 2011 14:19:47 GMT

hi thx its working without Error. its simlary to SqlServer IN Statement ?

thx

Error im geeting while using in statement in Sql

maneshkhottcpl — Fri, 04 Feb 2011 14:24:43 GMT

U can use this code.

where match(Quarter,'1')>0;

Error im geeting while using in statement in Sql

Anonymous — Fri, 04 Feb 2011 14:28:24 GMT

Similar but not exactly.
match() is comparing the exact case-sensitive values
wildmatch() is case-insentive, and you can use wildcards: wildmatch(field, '*abc*', '*de*', '*fg*'). Someithnig you can compare to "like", but for multiple values.

Error im geeting while using in statement in Sql

srinivasa1 — Fri, 04 Feb 2011 14:28:28 GMT

hi thx its working without Error.

But No date retrived

Its simlary to SqlServer IN Statement ? or exactely replacing my OR Condtion?

Error im geeting while using in statement in Sql

srinivasa1 — Fri, 04 Feb 2011 14:33:39 GMT

Thx Michale oncce agian.

but how can achive this .i dont want to considred case sensetive value.?how can i use wildcards?same sa wildmatch.i wll check my end too for wildcards

srini

Error im geeting while using in statement in Sql

maneshkhottcpl — Fri, 04 Feb 2011 14:48:47 GMT

Hi,

U cane use Wildmatch(FieldName,'*ABC')>0

will match the end string with ABC and starting with any.

'ABC*' will start with ABC and end with any.

Error im geeting while using in statement in Sql

Anonymous — Fri, 04 Feb 2011 14:55:57 GMT

Correct Manesh,
I only can add that the ">0" part is optional, it is implied. There is no difference between
Wildmatch(FieldName,'*ABC')>0
and
Wildmatch(FieldName,'*ABC')

Error im geeting while using in statement in Sql

srinivasa1 — Fri, 04 Feb 2011 16:17:50 GMT

I think its not working for me is im doing something wrong in script as bellow.

where

ReviewStatus ='N' OR ReviewStatus='R' OR ReviewStatus='RED' OR ReviewStatus='YELLOW' and ConsolidationFlag='NO';

where Wildmatch(ReviewStatus,'N','R','RED','YELLOW') and ConsolidationFlag='NO';

Error im geeting while using in statement in Sql

Anonymous — Fri, 04 Feb 2011 16:27:55 GMT

Obviously you'll get diferent results. The first one should be:
(ReviewStatus ='N' OR ReviewStatus='R' OR ReviewStatus='RED' OR ReviewStatus='YELLOW') and ConsolidationFlag='NO'