applying multiple conditions on qvd

[#1]

hi

i have the script am loading data from QVD

LOAD Month,

     [Salesman ID],

     [Customer ID],

     [Transaction ID],

     Year,

     Day,

     [Product ID],

     [Serial No],

     [List Price],

     Sales,

     [Gross Margin]

FROM

(qvd)where Year=2008 and [Product ID]=2000 ;

i need this out put:

Sales  of

YEAR=2008,2006 and [Product ID]=2000,1000

[alexandros17]

LOAD Month,

     [Salesman ID],

     [Customer ID],

     [Transaction ID],

     Year,

     Day,

     [Product ID],

     [Serial No],

     [List Price],

     Sales,

     [Gross Margin]

FROM

(qvd)where (Year=2008 or Year=2006) and ([Product ID]=2000 or [Product ID]=1000);

let me know

[ashfaq_haseeb · Accepted solution]

Hi,

Try below

LOAD Month,

     [Salesman ID],

     [Customer ID],

     [Transaction ID],

     Year,

     Day,

     [Product ID],

     [Serial No],

     [List Price],

     Sales,

     [Gross Margin]

FROM

(qvd)where match(Year'2008','2006') and match([Product ID],'2000','1000');

Regards

ASHFAQ

[its_anandrjs]

Load your script like

LOAD Month,

     [Salesman ID],

     [Customer ID],

     [Transaction ID],

     Year,

     Day,

     [Product ID],

     [Serial No],

     [List Price],

     Sales,

     [Gross Margin]

FROM

(qvd)

where ( Match(Year,'2008','2006') and Match([Product ID],'2000','1000') );

[PrashantSangle]

Hi,

Try with wildmatch() also

Like

where Wildmatch(Year,'2008','2006') and Wildmatch([Product ID],'2000','1000')

Regards,