Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
neha_sri
Creator III
Creator III

data Loading

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.

4 Replies
Not applicable

In the script:

Table1:

Load *

from Datasources.xls

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

Not applicable

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

LOAD *

FROM ABC

WHERE .....

Not applicable

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.

amit_saini
Master III
Master III

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,

AS