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:
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:
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!
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.
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
View this on-demand webinar about APIs....