Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.