topic Re: Load only data where exist in QlikView

Load only data where exist

Tue, 07 Feb 2017 09:51:35 GMT

I have this table as shown above from loading. How to I just load those that the UserID is A9900899?

Re: Load only data where exist

surendraj — Tue, 07 Feb 2017 09:56:14 GMT

In Script

Where clause

where match(UserID,'A9900899');

Re: Load only data where exist

Tue, 07 Feb 2017 10:02:11 GMT

I got this table by running the script below.

AccessControl:
LOAD UserID,
M_ENTITY,
VALUE
FROM
Access.xlsx
(ooxml, embedded labels, table is Sheet1);

OUTER JOIN

LOAD M_ENTITY
FROM
[Data\LNBR_2016-09-30.xlsx]
(ooxml, embedded labels, table is DATA);

How do I just load those that has UserID A9900899? I cant put the where match(UserID,'A9900899'); after the last load because they say UserID not found. please help thanks

Re: Load only data where exist

avinashelite — Tue, 07 Feb 2017 10:07:16 GMT

Try like this

AccessControl_temp:
LOAD UserID,
M_ENTITY,
VALUE
FROM
Access.xlsx
(ooxml, embedded labels, table is Sheet1);

OUTER JOIN

LOAD M_ENTITY
FROM
[Data\LNBR_2016-09-30.xlsx]
(ooxml, embedded labels, table is DATA);

AccessControl:

noconcatenate

LOAD *

resident

AccessControl_temp

where UserID='A9900899';

drop table AccessControl_temp;