Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Resident load

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Resident load

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

5 Replies
Not applicable

Re: Resident load

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

qv_testing
Valued Contributor

Re: Resident load

Hi,

Only using Resident Table_Name

Employee:

LOAD country,

     salary

Resident EMP;

Not applicable

Re: Resident load

hi

use like this

RESIDENT EMP;

if you want to remove EMP table just use DROP TABLE

regards

Gernan

Not applicable

Re: Resident load

tanq u

Not applicable

Re: Resident load

Hi Vinay,

Resident is followed by table name only not as

Resident as emp  //wrong

Resident emp      //Right

employe:

load country,sal

Resident emp;

Community Browser