Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
chris_mccann
Contributor
Contributor

How do I exclude, using a WHERE clause, all fields that contain 'INTF' in the Purchase Invoice Description, somewhere?

This is what i am doing at the min:

LOAD ProteanTPObjectID,
          PurchaseInvNo,
          CalendarLink,
          ProteanInvCreateDate,
          ProteanInvValue,
          ProteanInvStatus,
          ProteanInvSite,
          ProteanInvType,
          DocuWareInvTotalAmount,
          DocuWareInvStatus,
          ProteanTPDesc,
          ProteanInvDesc
    
FROM $(datasource)PI_DocUWare_Invoice.qvd (qvd);

WHERE ( ProteanInvSite <> 'S05'
AND  ProteanInvSite <> 'S06'
AND  ProteanInvSite <> 'S35')
AND   (LEFT(PurchaseInvNo,3) <> 'POI');

0 Replies