topic tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column in Talend Studio

tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column

Anonymous — Wed, 25 Apr 2018 05:34:10 GMT

I need to prevent tAdvancedFileOutputXML from creating empty elements. Basically there are rows in tAdvancedFileOutputXML which have no mapping from tMap so the corresponding elements should not be created. Please help

Re: tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column

Anonymous — Thu, 26 Apr 2018 04:53:04 GMT

Hello,

Here is an option "Create empty element if needed" in Advanced settings of tAdvancedFileOutputXML component.

Have you tried to uncheck it to see if it is OK?

Best regards

Sabrina

Re: tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column

Anonymous — Thu, 26 Apr 2018 12:28:05 GMT

Hi,

This was the very first thing I tried but seems that doesnot works the way it states because it still shows empty elements

Re: tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column

manodwhb — Fri, 27 Apr 2018 06:39:18 GMT

@aishvarya,can you share your smaple input and requied out ,so that i wil test.

Re: tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column

manodwhb — Fri, 27 Apr 2018 06:51:26 GMT

,i have tested please check the below way is usefull to you?

Re: tAdvancedFileOutputXML- Prevent creation of empty elements if there is no mapping for a column

Anonymous — Mon, 14 May 2018 10:47:41 GMT

I tried but still getting elements in xmls, I placed &nbsp in the mapping column in the xml rows mentioned in tAdvancexmloutput. Moreover I came across one more issue where if a mention a single space in the column data, ie " ".toString the corresponding xml element in the generated xml gives me two spaces. Need help on this too.