Filter Record based on condition at HANA View

[Former Member]

Hi All,

I have a requirement where I need restrict data(records) of HANA View based on below condition.

ORDER	DELIVERY	MATERIAL	DATE	QTY
101	801		02032016	100
102	802	MAT2	03032016	200
103		MAT3		300
104	803	MAT4		400

Out of above data, I need records which has data at columns DELIVERY, MATERIAL and DATE.

Means, I need ORDER : 102.

When I preview data of my CALCULATED VIEW, I need only one record(ORDER -102) out of 4.

How can I achieve this at HANA Calculation View end.

Thanks.

[kr_pavankumar · Accepted solution]

Hi Ram,

It can achieved in Projection node filters. This projection node shouldn't be the default one. Apply the filters on all the required columns. If ''is not null" is not working, then set "not equal to" either blank or space. This should work. Once done check the filter expression. Thanks.

--

KRPK

[Former Member]

Hi Ram,

You have to use the filter in the projection node in the calculation view. I simulated your requirement and this is how I implemented.

In the filter used the expression highlighted in red.

Here is the output:

Regards,

Amit

[Former Member]

Hi Amit,

I applied filter as you mentioned, but still null values are coming.

Is there we need deal in different any for "Spaces" ?

BR.

[Former Member]

Hi Ram,

Your requirement can be achieved by applying Is not NULL filter on Deliver, Material and Date fields.

Apply Is not Null filter on Delivery it exclude Order = 103 and similarly

Apply Is not Null filter on Material it exclude Order = 101 and

Apply Is not Null filter on Date it exclude Order =103 and 104 and

Then final output is as you required which is Order =102. 

Regards,

Kotesh