Resident

[#1]

Hi,

I am getting the error while trying to use the resident .

a. I am loading the data from database through the select statement .

b.After load statement i have used the Cross table and converted the columns to rows.

Till this it is working fine.

Now i trying to manipulate the crosstable data .since it is loaded in memmory i am trying to using the Resident keyword to access the loaded data. but i am getting error as table not found at the resident code. please find the code ia have used.

TEMP:

crosstable(dtype,Dte,2)

Load

CNO,

CTNO,

LTM,

CTM;

SQL SELECT

CUID as CNO,

TICKETNO As CTNO,

LOGGEDTIME As LTM,

CLOSEDTIME As CTM

FROM test Where CUID in ('1','2','3','4');

TEMP1:

Load

CNO,

CTNO,

DTYPE,

DTE,

YEAR(DTE),

MONTH(DTE)

RESIDENT TEMP;

[#2]

I think it might be that as you are using a preceding load that the resident table created as a result of the SQL statement has an internal name and the load proper is also associated with that name. Run the script in debug and step through it and see what table name is being created or use an 'exit script' after the SQL statement then see what 'table viewer' shows.

Regards,

Gordon

[#3]

Hi gordan,

Thanks for your response. And i mistakenly updated the error as Table not found. But the Actual error is field not found in the Resident Query......

[#4]

HI,

The fieldname DTYPE in the last load does not exist. It should be dtype. (Qlikview is case-sensetive)

/D

[#5]

Hi daniel,

Thats true Qlikview is case sensitive. i have changed accordingly and it is working fine now.................

thanks for your response................