topic Re: tHMap how to exclude blank values for if then statement in Talend Studio

tHMap how to exclude blank values for if then statement

Edith1 — Sat, 16 Nov 2024 01:59:14 GMT

Is there a way to exclude blanks or nulls after using an if then statement in Data Mapper?

Here's the tHMap - I'm using the if then statement for output field Type, but since there's more types, they're being written as blanks or nulls. How do I exclude values I don't want?

Here's the result of the test run. I don't want to write out the Type with blanks or nulls (highlighted fields on screenshot below). Is there a way to map an if then statement and then check if that same field has a value?

Re: tHMap how to exclude blank values for if then statement

manodwhb — Sun, 05 Jul 2020 03:25:25 GMT

You can exclude null values,for the blanks you need to convert blank to null.

Re: tHMap how to exclude blank values for if then statement

manodwhb — Sun, 05 Jul 2020 03:25:25 GMT

You can exclude null values,for the blanks you need to convert blank to null.

Re: tHMap how to exclude blank values for if then statement

Edith1 — Wed, 08 Jul 2020 22:37:26 GMT

How would I remove null rows? The mapper is writing the output as an array for that one column.

Re: tHMap how to exclude blank values for if then statement

Edith1 — Wed, 08 Jul 2020 22:37:26 GMT

How would I remove null rows? The mapper is writing the output as an array for that one column.