[resolved] tFileOutputMSXML component and empty XML elements

[Anonymous]

With tFileOutputMSXML component I am creating XML file which has empty elements inside. But I don't want empty elements inside my XML.
How can I set tFileOutputMSXML component in order that it wouldn't create empty XML elements in the XML file? 

[Anonymous]

Hi,
There has been a checkbox "create empty element if needed" in the panel "Advanced setting" of tFileOutputMSXML component.
When it is unchecked, the null input data will not generate an element.
If the input data is an empty string, please make use of tReplace, it will help displace the empty string with null.
Let us know if it is Ok with you.
Best regards
Sabrina

[Anonymous]

Thanx, will check this solution and report back.

[Anonymous]

I checked it with tFixedFlow and tMSXMLOutput and with tReplace and it works as expected.

[Anonymous]

Hi,
Great this solution works and thanks for your prompt reply.
 Can we consider this topic as resolved?
Best regards
Sabrina

[Anonymous]

yes we can mark it as resolved.

[Anonymous]

Hi,
Marked this topic as resolved.
Feel free to let us know if there is any further help we can give.
Best regards
Sabrina