Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to fetch the data from SAP DSO using SAP DSO connector. While fetching the data I want to fetch Invoice Clearing Date with blank value.
I have seen different options for where clause like EQ NE CP in QlikView SAP Connector manual but i am not sure how to utilise this option to fetch field with blank value.
Could you please some one help me on this?
Thanks & Regards,
Bhavik
Can u tell me exactly what you want to do with Where condition?
Hi Anil,
I want to fetch only those INVOICE_NO against which there is no CLEARING_DATE.
For this in where clause i want to mention CLEARING DATE as blank or null.
Hi Bhavik,
This should work. If not, please post snapshot of your SAP data.
DSO_NAME:
Load * Where Len(Trim(CLEARING_DATE))=0 ;
SQL Select (NoKey) Invoice_No,
CLEARING_DATE
from DSO_NAME;