topic Re: Resident load in QlikView

Resident load

Thu, 03 Oct 2013 07:54:45 GMT

hi i am new to sap ,can u help me to get the result , see the attached files

EMP:

LOAD empid,

deptno,

empcity,

country,

salary

FROM

C:\qlikview\p2.xlsx

(ooxml, embedded labels, table is Sheet3);

Employee:

LOAD country,

salary

Resident as EMP;

Message was edited by: vinay a

Thu, 03 Oct 2013 08:10:50 GMT

RESIDENT is followed by the table name not by "as"

Nagaraju_KCS — Thu, 03 Oct 2013 08:23:12 GMT

Hi,

Only using Resident Table_Name

Employee:

LOAD country,

salary

Resident EMP;

Thu, 03 Oct 2013 08:25:38 GMT

use like this

RESIDENT EMP;

if you want to remove EMP table just use DROP TABLE

regards

Gernan

Thu, 03 Oct 2013 08:30:08 GMT

tanq u

Mon, 14 Apr 2014 13:05:46 GMT

Hi Vinay,

Resident is followed by table name only not as

Resident as emp //wrong

Resident emp //Right

employe:

load country,sal

Resident emp;