topic [resolved] tFileOutputMSXML component and empty XML elements in Talend Studio

[resolved] tFileOutputMSXML component and empty XML elements

Anonymous — Thu, 07 Jul 2016 14:49:39 GMT

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?

Re: [resolved] tFileOutputMSXML component and empty XML elements

Anonymous — Tue, 12 Jul 2016 08:41:26 GMT

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

Re: [resolved] tFileOutputMSXML component and empty XML elements

Anonymous — Thu, 14 Jul 2016 08:34:19 GMT

Thanx, will check this solution and report back.

Re: [resolved] tFileOutputMSXML component and empty XML elements

Anonymous — Sat, 16 Jul 2016 08:56:59 GMT

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

Re: [resolved] tFileOutputMSXML component and empty XML elements

Anonymous — Mon, 18 Jul 2016 08:59:38 GMT

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

Re: [resolved] tFileOutputMSXML component and empty XML elements

Anonymous — Mon, 18 Jul 2016 10:10:34 GMT

yes we can mark it as resolved.

Re: [resolved] tFileOutputMSXML component and empty XML elements

Anonymous — Tue, 19 Jul 2016 10:14:15 GMT

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