topic Re: tMap null values in Talend Studio

tMap null values

DrGenious — Sat, 16 Nov 2024 03:51:13 GMT

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.

Re: tMap null values

manodwhb — Thu, 12 Dec 2019 11:36:46 GMT

@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

Re: tMap null values

DrGenious — Thu, 12 Dec 2019 11:47:45 GMT

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.

Re: tMap null values

manodwhb — Thu, 12 Dec 2019 12:02:25 GMT

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

Re: tMap null values

Anonymous — Thu, 12 Dec 2019 13:39:55 GMT

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