MSXML Output

Highlighted
Five Stars

MSXML Output

Hey Guys,

 

I'm using the tMSXML Output in my project. I need a special Structure (XML-Tree) in my Output.

 

As you can see below, I have one attribute for the value and one attribute for the field naming:

 

txml_out_2.PNG

 

 

If there is a NULL-Value, the first attribute (for the value) is not shown in my XML for a record. The second attribute (for the field naming), will be printed in every case, independently if there is a NULL-Value or not. You can see this in the XML-Output below:

 

Example_XML.PNG

In other words: Field "IDT102" is "4", Field "IDT107" is "4" and Field "IDN108" is "NULL".

 

Now my question: it is possible to modify the MSXML Component in that way that, if there is a NULL-Value for a field (in the exampe "IDN108"), that the whole row ("value" and "fieldname" will not be printed in the XML. So I want both to disappear if there is a NULL-Value?

 

Thanks so much for your participation!

 

 

Four Stars DPE
Four Stars

Re: MSXML Output

Hi 

You can use the tAdvancedFileOutputXML component and uncheck the box Create empty element if needed,create attribute even if its value is NULL options in Advanced Settings.

 

Four Stars DPE
Four Stars

Re: MSXML Output

t1.JPGt2.JPG

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now