data Loading

[neha_sri]

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.

[#2]

In the script:

Table1:

Load *

from Datasources.xls

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

[#3]

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

LOAD *

FROM ABC

WHERE .....

[#4]

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]

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