Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Excluding data

Hello,

I would like to exclude data in my data load editor script, how can I write this?

would like to have all data exept the data connected to companyX.

Can I write like this?

Where not match([BookingCompany],'CompanyX')

7 Replies
sunny_talwar

Looks good to me. Is it not working? Alternatively you can also try this:

Where BookingCompany <> 'CompanyX';

Gysbert_Wassenaar

Yes, that looks correct.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

No it is not giving me the correct result, can it be that I have made so many selections in my dataset?

LOAD [BookingDate],

[SalesPerson],

[AlfaCompany],

[AssignmentNumber],

[AssignmentType],

[BookingCompany],

[OpenOrClosed],

[Assignee],

[OriginCity],

[OriginCountryCode],

[DestinationCity],

[DestinationCountryCode],

[LoadingDate],

[UnloadingDate],

[Volume],

[NetWeight],

[InsuranceValue],

[InsuranceValueProc],

[Household],

[InsuranceCurrency],

[MoveManager],

[StandardInsured],

[TransportInsurenace],

[SetAndParInsurnace],

[ElectronicInsurance],

[SetAndParInsurnaceProc],

[ElectronicInsuranceProc],

[PerformanceDate]

FROM

(qvd)where match([StandardInsured],'1') or match([Household],'1') or match ([TransportInsurenace],'1') or (([InsuranceValue])>'1')

and ([BookingCompany]<>'32038')

Should I write the last portion concerning booking company separate in some way?

jagan
Luminary Alumni
Luminary Alumni

YOu can also simply write

Where [BookingCompany] <> 'CompanyX';


For case insensitive

Where Not  Mixmatch([BookingCompany], 'CompanyX');


Hope this helps you.


Regards,

Jagan.


Not applicable
Author

your brackets look to have gone astray.

where (match([StandardInsured],'1') or match([Household],'1') or match ([TransportInsurenace],'1') or [InsuranceValue]>'1')

and [BookingCompany]<>'32038'

this will return records where BookingCompany is not '32038' AND one (or more) of the other requirements are met.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this

FROM

(qvd)

where ([StandardInsured]= 1 or [Household]=1 OR [TransportInsurenace]= 1  or[InsuranceValue] >'1')

and [BookingCompany]<>'32038'

reddy-s
Master II
Master II

Hi Madeleine,

You even make use of "where not exists()"

Thanks,

Sangram.