topic problem with load statement with where clause in QlikView

problem with load statement with where clause

Wed, 11 Nov 2009 13:45:31 GMT

hi,

i m using load statement with where clause to load party_name whose party_code is 02 .as a result i m getting

some party_name which doesn't exists in original table and no of records are more than that of actual table.

code snippet:-

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 with load statement with where clause

Wed, 11 Nov 2009 13:52:16 GMT

please put where cluse here

FROM "NEWTON_BI1"."COR_PARTY_M" where ;

problem with load statement with where clause

Wed, 11 Nov 2009 17:11:12 GMT

i have already tried it, but result is same.

i have some extra unrecognised fields like 'zzzzzzzzzzz' , 'zzzzzzNOT USED' , '********R.K. ENTERPRISE' etc in the party_name list box.

i m unable to trace from where they r coming?

problem with load statement with where clause

prieper — Sun, 15 Nov 2009 02:11:24 GMT

Do not think that QV invents some new fields - would guess that these fields are actually in your database (and probably not visible in the usual forms). If you are in doubt, try to retrieve the very same with a native SQL-query.

Peter

problem with load statement with where clause

Tue, 17 Nov 2009 17:26:20 GMT

Hi Newlearner

Your LOAD overlay is almost there. Below is an extract on how it could be done.
The * needs to be in the LOAD, the FIELDS in the SELECT and the WHERE also in the SELECT.
Hope it solves your problem.

code

"TEMP":
load *,
year(PostingDate)*12+month(PostingDate) as BaseTransactDate
;
SQL SELECT
DomainCode+CompanyCode as [%COMPANY CODE],
DomainCode+DivisionCode AS [%SUB ACCOUNT CODE],
CurrencyCode as "TRANSACTION CURRENCY",
PostingYearPeriod,
PostingDate,
POSTINGLINELC,
DOMAINCURRENCYCODE AS "BASE CURRENCY D"
FROM BI.dbo."VW_CUSTOMER_TXN"
where "DomainCode" IN ($(zDomains));

/code