If length = 10 then pass to Valid table otherwise pass record to Invalid table

[Amit4]

Hi,

I have tDbinput to get data from input table. Then I am using tmap to push the Data to Valid and Invalid tables.

I have one Key column which length should be 10 and it should be integer. If it contains any character it should go to invalid table. 

Flow:  input--->tmap-->validation(length 10 & all integers) - if true - > Valid table

                                                                                                 else -->Invalid table

Thanks in Advance!

Amit

[Shicong_Hong]

Hello 

Add a filter condition for the validate output table, set the condition as:

row1.columnName.length()==10&&Mathematical.NUM(row1.columnName)==1

Add a filter condition for invalidate output table, set the condition as:

!(row1.columnName.length()==10&&Mathematical.NUM(row1.columnName)==1)

Regards

Shicong

[Amit4]

Hi Shicong,

Thanks for your response but when I am putting length function in tMap. I am getting this error.

Type mismatch cannot convert from Boolean to String.

FYI: The column on which I am applying that is String data type.

Thanks

[Shicong_Hong]

Write the Java code in the filter expression field.