topic Re: data Loading in QlikView

data Loading

neha_sri — Wed, 21 May 2014 09:05:29 GMT

Hi All,

I have some data but I have a limitation that during data loading I want to exclude particular 3 values from them.

How to do that.

Re: data Loading

Wed, 21 May 2014 09:07:36 GMT

In the script:

Table1:

Load *

from Datasources.xls

where Field<>'A' and Field<>'B' and Field<>'C';

Re: data Loading

Wed, 21 May 2014 09:08:00 GMT

This depends on the data source you are loading from, generally this would be done using your WHERE criteria:-

LOAD *

FROM ABC

WHERE .....

Re: data Loading

Wed, 21 May 2014 09:26:09 GMT

Hi Neha,

When you load the table into the script use a where clause if you are doing a SQL select or a plain file.

If you load the data from a QVD file use EXIST or NOT EXIST clause.

If you post more details maybe we can give you more precise response.

Regards.

Re: data Loading

amit_saini — Wed, 21 May 2014 09:47:36 GMT

Hi Neha,

Suppose in Status field i am having values like Open , Closed , Withdrawn and I don't want to show "Withdrawn" inside Status than below is the script example:

LOAD

ID as TicketID,

Description,

IDClient,

Urgency,

Impact,

ErrorType,

STATUS as Status,

Application,

CAT_ID as Category3,

Type

FROM

[..\SRC\QVD\abc.qvd]

(qvd)

Where STATUS <>'Withdrawn';

Thanks,