Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Bring in only NULL Values to a QVD

I am pulling from SAP and I need to only pull data in based upon a field CUST_GRP3 where there is no data in the field, I tried a few things but can't seem to bring in the expected results.  Basically I only want to return values that are NULL in CUST_GRP3 .   Here is my script:

VW_R_NAM_CUST_SALES_ORG:

LOAD SAP_CUST_NBR,
SALES_ORG,
DIST_CHANNEL,
DIVISION,
CUST_NAME,
STREET,
CITY,
STATE_PROV,
POSTAL_CODE,
CNTRY_CD,
CUST_GRP1,
CUST_GRP2,
CUST_GRP3,
CUST_GRP4,
CUST_GRP5,
CUST_GRP,
SO_AUTH_GRP,
SO_DELETE_IND,
SO_ORDER_BLOCK_CD,
PRICE_GRP,
PRICE_LIST,
INCOTERMS,
INCOTERMS2,
SO_DELIVERY_BLOCK,
SHIP_COND,
SO_BILLING_BLOCK_IND,
CURR_CD,
ABC_CD,
ACCT_ASSIGN_GRP,
PAY_TERMS_CD,
SO_SALES_BLOCK_IND,
NFA,
RFA,
TELE1,
FAX_NBR,
ACCT_GRP,
CUST_CLASSIF,
COMP_POST_BLOCK_IND,
INDUS_CD1,
INDUS_CD2,
INDUS_CD3,
INDUS_CD4,
INDUS_CD5,
PAY_BLOCK_IND,
CENTRL_SALES_BLOCK,
DELETE_BLOCK,
SALES_OFFICE,
SALES_GROUP

SQL SELECT *
FROM
$(vSchemaName)."VW_R_NAM_CUST_SALES_ORG";


STORE VW_R_NAM_CUST_SALES_ORG into [$(vToQVD)\VW_R_NAM_CUST_SALES_ORG.qvd] (qvd);

Drop Table VW_R_NAM_CUST_SALES_ORG;

1 Solution

Accepted Solutions
Not applicable

Re: Bring in only NULL Values to a QVD

Turns out I found my resolution, the database system is setup to insert a # instead of a null, so I was able to do a WHERE MATCH function, thank you both for your help.

3 Replies
MVP
MVP

Re: Bring in only NULL Values to a QVD

did you try to add a filter to the load?

Load

     ....

     SALES_GROUP

where

     len(trim(CUST_GRP3 )) = 0;

SQL

     select

          ......

     ;

Not applicable

Re: Bring in only NULL Values to a QVD

HI Massimo,

Load

     ....

     SALES_GROUP

where

     isnull(CUST_GRP3 ) = true();

SQL

     select

          ......

     ;

Not applicable

Re: Bring in only NULL Values to a QVD

Turns out I found my resolution, the database system is setup to insert a # instead of a null, so I was able to do a WHERE MATCH function, thank you both for your help.

Community Browser