Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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')
Looks good to me. Is it not working? Alternatively you can also try this:
Where BookingCompany <> 'CompanyX';
Yes, that looks correct.
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?
YOu can also simply write
Where [BookingCompany] <> 'CompanyX';
For case insensitive
Where Not Mixmatch([BookingCompany], 'CompanyX');
Hope this helps you.
Regards,
Jagan.
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.
Hi,
Try this
FROM
(qvd)
where ([StandardInsured]= 1 or [Household]=1 OR [TransportInsurenace]= 1 or[InsuranceValue] >'1')
and [BookingCompany]<>'32038'
Hi Madeleine,
You even make use of "where not exists()"
Thanks,
Sangram.