tMap null values

[DrGenious]

HI,

I want to filter my rows in tMap  not to be  null ,but I want to ask if there is any other way instead of write an exception for every row. Thank you.

[manodwhb]

@DrGenious , you want to filter the not null values then follow the below way expression in Enable/disable expression filter of output section of tMap.

row1.col1!=null

[DrGenious]

Instead of check every column couldn't We check all together somehow? 

For example :

I have the columns id,first,name. I know that i can check them like row1.id !=0 && row1.first !=0 . But if We have 100 columns how  We can check them all together? Thank you.

[manodwhb]

@DrGenious , simple answer, you have to write for each and every field.

[Anonymous]

Hi,

    You can also use tSchemaComplianceCheck component where you can do the same operation in a graphical manner. You can refer the details of this component from below link.

https://help.talend.com/reader/Dd2fibuWXEDgCeT1g0qZGA/UAMwdeOQYc4Gu7VHb5Wv~w

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved