Using Filter rows

[aprilab]

I want to check if a field is empty or not. How can I make it in Filter Rows?

Pls help.

Thanks

[bugg_tb]

Well surely its if the field = null then send to the true output step if it = false then is goes to the false output step.

[aprilab]

Thank you

[christophWeißenborn]

There is a difference between NULL and empty (String/Varchar).
Check for NULL is made with "value IS NOT NULL" (in both Kettle and SQL).
Check for emptiness is done with "LEN(value) = 0" in SQL or '= "" ' in Kettle.

Christoph

[aprilab]

so what will i particularly place in the 'value' box in Filter Rows? Is it ok if I will put there a "NULL" string?

[christophWeißenborn]

I do not know which condition you need. Your input values predefine that.
To build your condition do
1. choose the field
2. choose the function: "IS NULL" or "="
if appropriate 3. choose the value (for comparing)

Point 3 is not appropriate if you choose "IS NULL".