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

chris_mccann — Mon, 12 Nov 2012 15:45:06 GMT

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

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

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