Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
coco2
Contributor
Contributor

Remove/Ignore empty fields in tMap-Output

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?

Labels (2)
1 Reply
Ray0801
Creator
Creator

@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.