Remove/Ignore empty fields in tMap-Output

coco2 — Fri, 15 Nov 2024 23:49:40 GMT

Hi,

I'm using the free Version of Talend and i'm trying to transform a csv-File via tMap and i want it to ignore input Objects in my Output when they're empty strings. I tried to add this: "row1.Comment1.equals("")?null:("667 " + row1.Comment1)", but it still prints an empty field when i pipe it to tFileOutputDelimited. Is there any way to remove this empty field without writing a new component?

Re: Remove/Ignore empty fields in tMap-Output

Ray0801 — Mon, 23 Aug 2021 11:38:01 GMT

@Corinna Kiekenbeck You can use the filter in tMap if you don't want the empty columns in the output.

Try !(row1.Comment1.equals("")) inside the filter.

The function you have writen will replace a empty field with null.

topic Re: Remove/Ignore empty fields in tMap-Output in Talend Studio

Remove/Ignore empty fields in tMap-Output

Re: Remove/Ignore empty fields in tMap-Output