Blank value using tfilterrow

[BA621858188]

Hi All,

I want to check and filter blank values from a file based on an integer column and using the tfilterrow component. How can I use the tfilter row component properties. Can anyone help me on this?

I am doing currently as below:

column - (integer column)

function - empty.

operator - equals

value - ""/'' (this is giving me an error)

Appreciate your help.

[rhall1]

Your value suggests that the column is not an Integer or int column.

[BA621858188]

The column is integer. I need your help to know how can I check blank in it using tfilter row.

[BA621858188]

@Shicong Hong​ , can you please help here?

[rhall1]

Are you sure that the column is set to Integer? This value....

""/''

...is not what you would expect of an Integer. It looks more like a String.

I am talking about the column type, not the expected the value.

[Anonymous]

set the value as null, and make sure the key box of the column is checked on the schema of input component.

[BA621858188]

@Shicong Hong​ ,

I tried this. getting below error:

The operator == is undefined for the argument type(s) int, null

column - (integer column)

function - empty.

operator - equals

value - null

selected key box for the column as well

[Anonymous]

sorry, it is the 'nullable' box, this option should be checked on the schema.

[BA621858188]

Hi @Shicong Hong​ ,

I tried this as well but no luck. Kindly help.

Below is the design:

tDBInput-->tfileoutputdelimited-->tfilterrow-->tfileoutputdelimited

tfilterrow

ID Empty not equal to null

[tnewbie]

I am able to filter rows easily where a specific column is null.

I have taken 2 integer columns c1 and c2. I have inserted 2 rows, 1st row where both c1 and c2 have values, 2nd row where c2 is null

I am able to take forward only the 2 row where c2 is null

Please try this

Hope this helps