Resident load

[#1]

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

[#2 · Accepted solution]

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

[qv_testing]

Hi,

Only using Resident Table_Name

Employee:

LOAD country,

     salary

Resident EMP;

[#4]

hi

use like this

RESIDENT EMP;

if you want to remove EMP table just use DROP TABLE

regards

Gernan

[#5]

tanq u

[#6]

Hi Vinay,

Resident is followed by table name only not as

Resident as emp  //wrong

Resident emp      //Right

employe:

load country,sal

Resident emp;