Excluding data

[Anonymous]

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')

[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.

[Anonymous]

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]

YOu can also simply write

Where [BookingCompany] <> 'CompanyX';

For case insensitive

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

Hope this helps you.

Regards,

Jagan.

[#6]

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]

Hi,

Try this

FROM

(qvd)

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

and [BookingCompany]<>'32038'

[reddy-s]

Hi Madeleine,

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

Thanks,

Sangram.