topic problem using load with where clause in QlikView

problem using load with where clause

Tue, 10 Nov 2009 19:42:51 GMT

hi guys!!

i have two fields in table party_master namely party_type & party_name. i have to choose those party_name which have party_type=2. for this i m using where clause with load statement.

but it shows some those party names which even doesn't exists in the table. some of the names includes * sign at their begining also.

any suggestion would be appreciated..

problem using load with where clause

agsearle — Tue, 10 Nov 2009 19:49:37 GMT

Can you show us the script you have so far?

problem using load with where clause

Tue, 10 Nov 2009 21:37:35 GMT

Do you have another field in another table that is named the same? Then it would be data from that table that you see.

problem using load with where clause

Wed, 11 Nov 2009 11:59:11 GMT

thanks for reply,

no, actually each fields are made unique with prefixes like party party_party_name, sales_party_name etc. in different tables.

problem using load with where clause

Wed, 11 Nov 2009 12:11:35 GMT

here is the script :-

ODBC CONNECT TO [odbc oracle2];

LOAD

"PARTY_LOCN_CODE",

"PARTY_PARTY_TYPE",

"PARTY_PARTY_CODE",

"PARTY_PARTY_CTGRY",

"PARTY_PARTY_CLASS",

"PARTY_PARTY_STS",

"PARTY_PARTY_NAME",

"PARTY_DIR_INDIR"

where

"PARTY_PARTY_TYPE"=02

;

SQL

SELECT

FROM

"NEWTON_BI1"."COR_PARTY_M";

problem using load with where clause

blaise — Wed, 11 Nov 2009 15:33:28 GMT

I think the problem is within the where "PARTY_PARTY_TYPE"=02 statement.

It should be "PARTY_PARTY_TYPE"=2 if the field is in number format, or "PARTY_PARTY_TYPE='02' if the field is a text (like varchar) field.

Try running the query from another query tool than Qv, just to be sure that Qv is messing something up. For a oracle db i would recommend SQL Developer (can be downloaded for free from oracles homepage). It's a wonderfull tool when working against an Oracle db.

Finally, i would but the where clause inside the select statement instead, but thats just me.