Where Clause

[Anonymous]

HI All

I need help with the following

I am loading in

Load

     %SaleId,

     Sale.StartDate_Day as %SaleStartDate,

     Sale.EndDate_Day    aS %SaleEndDate_Day,

     Sale.BrandName,

     Sale.SaleId,

     Sale.Currency,

     Sale.BranchName,

     Sale.Description,

     Sale.SaleNameNumber,

     Sale.HallNameNumber,

     Sale.UserGroupCodeAtImport,

     Sale.Name,

     Sale.Channel,

     Sale.Status,

     Sale.UserGroupCode,

     Sale.SaleGroup,

     Sale.AllowAnonymousLotAccess,

     Sale.PreviewDate,

     Sale.PreviewDate_Day,

     Sale.PreviewDate_Time,

     Sale.StartDate,

     Sale.StartDate_Day,

     Sale.StartDate_Time,

     Sale.ReminderDate,

     Sale.ReminderDate_Day,

     Sale.ReminderDate_Time,

     Sale.EndDate,

     Sale.EndDate_Day,

     Sale.EndDate_Time,

     Sale.xBidDate,

     Sale.xBidDate_Day,

     Sale.xBidDate_Time,

     Sale.SalePhaseStartDate,

     Sale.SalePhaseStartDate_Day,

     Sale.SalePhaseStartDate_Time,

     Sale.SalePhaseType,

     Sale.DCF

FROM $(vQVDLOADPATH)Sale.qvd (qvd)

where Sale.BrandName =  'ALSpain' or 'ALItaly' or 'BCSpain' or 'BCItaly'   And Sale.EndDate > '20/05/2014' And Sale.StartDate > '20/05/2014';

In the script but not getting the full results

Is this the best way to display the only selected data?

How can i write this with Set-Analysis to only load the Salebrands listed above in where clause?

Thanks

[maxgro · Accepted solution]

if you want to filter in the load (script) try with

where mixmatch(Sale.BrandName,  'ALSpain', 'ALItaly', 'BCSpain', 'BCItaly')   And Sale.EndDate > '20/05/2014' And Sale.StartDate > '20/05/2014';

[PradeepReddy]

Try the bellow condition...

Where (Sale.BrandName =  'ALSpain' or

          Sale.BrandName= 'ALItaly' or

          Sale.BrandName='BCSpain' or

          Sale.BrandName= 'BCItaly') 

And Sale.EndDate > '20/05/2014'

And Sale.StartDate > '20/05/2014';

we can achieve this in other way using Mixmatch(), as suggested by Massimo..

Regards,

Pradeep

[ashfaq_haseeb]

Hi use match function.

Regards

ASHFAQ