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

[ramoncova06]

so just from me to understand better

you extract your data and create this key [sales org]&'/'&[Customer kunnr]&'/'&[Distributed Channel] at what moment is this happening ?

In a table created before the where or during the where ?

if is during the where have you tried

where trim([sales org]&'/'&[Customer kunnr]&'/'&[Distributed Channel]) = '\\'

[#3]

Why not do this,

Load *

Where not isnull(salesorg) and not isnull(Customer kunnr) and not isnull(Distributed Channel);

SQL Select * From KNA1;

Not sure if I am missing something here.

[arusanah]

done that but not working

[kangaroomac]

Hi Arusanah,

For some reason it seems when you load from SAP, it does not recognise the '//' as a field value.

A work-around could be to:

"MyTable":

do the table load..

then do another load

"My New Table":

NoConcatenate Load

*,

....

Where <Field> <> '//';

DROP Table MyTable;

Your root cause though could be "missing" fields (Check Sub Set Ratio's in your data model and use where exists where applicable).