load data to qlikview

[#1]

hi,

i tried to load this table to a qvd file.

i just push the reload butten and the script immediately fall.

this is my script:

FACT_GVIYA:

LOAD 'FACT_GVIYA' as Fact_Key,

CORP_KEY,//

ORGNZ_KEY,//

AGENT_KEY,//

REF_KEY,//

COMP_KEY,//

PLS_KEY,//

INSUR_KEY,//

PREMIYA_TYP as FACT_GVIYA_PREMIYA_TYP,

TOT_PREMIYA as FACT_GVIYA_TOT_PREMIYA,

VIP as FACT_GVIYA_VIP,

SUG_BITUAH as FACT_GVIYA_SUG_BITUAH,

TOHNIT_BITUAH as FACT_GVIYA_TOHNIT_BITUAH,

KUPAT_GEMEL_LOGI as FACT_GVIYA_KUPAT_GEMEL_LOGI,

SIMAN_HAZRAMA_BE_KABALA as FACT_GVIYA_SIMAN_HAZRAMA_BE_KABALA,

SUG_KEREN_PENSIY as FACT_GVIYA_SUG_KEREN_PENSIY,

PAYMENT_MONTH as FACT_GVIYA_PAYMENT_MONTH ;

SQL SELECT *

FROM "BI_DWH".dbo."FACT_GVIYA"

where SIMAN_HAZRAMA_BE_KABALA='y' ;

Store FACT_GVIYA into $(QVD_PATH)FACT_GVIYA.qvd (qvd);

drop table FACT_GVIYA;

thanks

[#2]

i forgot to tell that i have a QVD_PATH as a verible in my model an asolid connect to oledb DB

thanks

[pat_agen]

Hi,

check your qvd path variable. Is it correct? If that is wrong the script will fail.

[#4]

hi

yes my qvd path is fine. i have changed it for several times.

if i load the table without the where statment its work fine but i want to filter it before loaiding to the model. (this table contain 4 M records...)

maybe my syntax is wrong?

[pat_agen]

hi,

looks to be thecase if you say load is succesful when you don't use the where clause. I don't knwo which dbms you are looking at so can't help you on the syntax.

But first up are you sure that the field SIMAN_HAZRAMA_BE_KABALA contains records with the value 'y' (in lower case)? The store command would fail if your table FACT_GIVYA was empty.

[#6]

i use the same filter on the table on sql server and its ok.

whe\at is the better way to load table with a filter to a qvd file? to load the all table and then use resident and filters?

[pat_agen]

I'd always recomend having your filter as you have it. that is restricting the maount of data you are pluuing out of your database. if you are not going to use it why bring it out?

I don't know sql server but obviously something is going wrong in your odbc interface. You say the query works if you have no "where" clause. So the problem is there.

Have you tried putting double quotes rather than single quotes around your y. Like this SIMAN-HAZRAMA_BE_KABALA = "y".

To test where you are at coment out your store and drop table command. You will then see if the table FACT_GVIYA contains any records.

By the way your store command shouldread like this:

Store FACT_GVIYA inot $QVD_PATH)FACT_GVIYA.qvd;

you don't need the (qvd). That is used when laoding the qvd back into a qvw.

[llauses243]

Hi Eladtest,

Generate .log & to send, thx

Luis.

[#9]

hi

i think i'll try to load this in a different way

thanks

elad