Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
In the script:
Table1:
Load *
from Datasources.xls
where Field<>'A' and Field<>'B' and Field<>'C';
This depends on the data source you are loading from, generally this would be done using your WHERE criteria:-
LOAD *
FROM ABC
WHERE .....
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.
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