Blank data coming from Data source

[arusanah]

customer Key
1100/12/90
1320/20/55
//
//
1459/25/10
1500/34/99
//
1100/12/90
1110/22/90

this is the data coming from SAP table .

i tried using following code to remove blank data and it is not working

From <table  name>

where (len(trim([Sales Organization_VKORG])) >0 and len(trim(Customer_KUNNR)) > 0 and len(trim([Division extension_DIVEXT]))> 0 );

pls help

[Karthik3]

// might not be blanks so try Len(TRIM([Sales Org..])) >2 OR WHERE Left(TRIM([Sales Org..]))<>'//'

[ramoncova06]

you could try with isnull also

(isnull(trim([Sales Organization_VKORG]))=0  and isnull(trim(Customer_KUNNR)) =0  and isnull(trim([Division extension_DIVEXT])) =0 )

though for this to work all three fields must have a value, otherwise use "or" instead of "and"

[arusanah]

still not working

[ramoncova06]

are the "//" part of the data or is that something you added to denote the null values ?

[danieloberbilli]

are the //  characters from the SAP table...so its way of indicating null values?

maybe like

...where trim([customer Key]) <> '//' 

[arusanah]

Hi Ramon,

I created a key column were '/' is separator

[sales org]&'/'&[Customer kunnr]&'/'&[Distributed Channel]

[arusanah]

Hi Daniel,

No they were not part of dataset .

I created a key column were '/' is separator

[sales org]&'/'&[Customer kunnr]&'/'&[Distributed Channel]

[danieloberbilli]

There might be more fields to consider in the WHERE ... clause.

Or maybe the where-clause is not working directly when loading from the SAP source directly. Try to load all the data (without 'where') in a table in Qlik and then use a second stage with a noconcatenate load resident where you use use the 'where' clause and drop the previous (full) table  

[arusanah]

If key is made up of only three fields  from table , what else should we check ?

i'm pulling only 5 field from KNA1 table in SAP in this dimension.

customer Kunnr , division , sales org, distribution channel, division extent