topic Re: removing blank columns from a row in Talend Studio

removing blank columns from a row

_AnonymousUser — Sat, 16 Nov 2024 14:17:06 GMT

I want to remove blank columns from a row, how is this possbile?
so lets say my row coming in from an xml file looks like this:
<row>
<name>tom</name>
<age>24 </age>
<sex/>
</row>
i read it in and i want to remove the sex column as its blank. how can this be done so that my ouput to an xml file looks like this:
<name>tom</name>
<age>24</age>

Re: removing blank columns from a row

Anonymous — Thu, 24 Jul 2008 06:56:01 GMT

Hello
There is an otpion 'Create empty element if needed' on advanced settings panel of tAdvancedFileOutputXML, uncheck this option to remove the empty element.
Best regards

shong

Re: removing blank columns from a row

_AnonymousUser — Tue, 14 Oct 2008 17:29:41 GMT

Hi,
I did that and its unchecked on another job I have and it doesnt work, it still prints out the element like this:
<cameraType></cameraType>
<ParentList/>

Re: removing blank columns from a row

Anonymous — Thu, 27 Aug 2009 10:46:29 GMT

How to remove the blank tag from the XML?
I have unchecked the checkbox which was present in the settings of tAdvanceOutputXml i,e; create empty element if needed. But still empty tag is occuring.
One thing i noticed that the tag which appeared <ParentList/> in this format works fine after unchecking the text box but the tag which is like <ParentList></ParentList> still comes.
Please guide how to handle this.

Re: removing blank columns from a row

Anonymous — Fri, 28 Aug 2009 07:51:52 GMT

Hello

One thing i noticed that the tag which appeared <ParentList/> in this format works fine after unchecking the text box but the tag which is like <ParentList></ParentList> still comes.

I tested and found that this option is invalid now. Please report a bug on our bugtracker.
Thanks for your support!!!
Best regards

shong