Problem with fields using resident

[#1]

Hi, Sorry, I have lots of SQL experience but new to Qlik.

I have a script that loads from an odbc connection and I want to then use it in a load using resident.

Even the simple one below gives a script error as

Field not found - <fwk_num>

trade_data: 

LOAD

fwk_num

RESIDENT trade_trans

What am I doing wrong?

I tried the unqualify command that I found when looking up these type of errors but it too didnt work.

I am using the free trial version at the minute as my company is still in the process of buying licences.

Is it a restriction of the trial version?

Script after the ODBC connect string is shown below.

Thanks for reading.

trade_trans:

Select

fwk_num

FROM

  dw.CALENDAR;

trade_data: 

LOAD

fwk_num

RESIDENT trade_trans;

store trade_data into 201422_trade.qvd;

[#2]

Can you provide your table's data in an excel?

[Colin-Albert]

Have you tried this - Remember QlikView is fully case sensitive, so the case of the filed names in the load section must exactly match the field names returned in your SQL Query.

ODBC CONNECT TO  ........

brtrans:

load

     fwk_num as ddf

;

SQL Select

     fwk_num

FROM

  dw.CALENDAR

  where fwk_num = 201422 ;

[maxgro · Accepted solution]

with this I get a field not found error on my oracle db

load

  cod_logalias;

SELECT

L.COD_LOG as cod_logalias

FROM DWH_DL.U002_LOG L

;

change to uppercase the field

load

  COD_LOGALIAS;

SELECT

L.COD_LOG as cod_logalias

FROM DWH_DL.U002_LOG L

;

oracle send an uppercase field

in the load you use a lowercase --> field not found

[#5]

At last.... Combination of reply's has helped.

It was the fact that I had to uppercase the field in the load to resident even thought the first sql was written in lowercase.

The code below now works!

Thanks to all who replied and its certainly one to take care on regarding the case of variables.

Thanks again.

brtrans:

Select

fwk_num

FROM

  dw.CALENDAR

  where fwk_num = 201422;

tdata:

LOAD

FWK_NUM as ddf

RESIDENT brtrans;

store tdata into 201422_trade.qvd;

DROP TABLE brtrans;