Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to keep null xml fields when using Field Flattener?

I'm Using streamset and have a nested XML which I need to parse into a .csv. When I apply the Field Flattener component, it flattens the xml, but it flattens stripping out the field with NULL values. example :

<xml>  <a>null</a>    <b>
       <c>hi</c>
       <d>NULL</d>    </b>    <b>
        <c>salut</c>
      <d>2</d>    </b> </xml>

output wanted in my excel :

|NULL   |   hi   |NULL |
|NULL   |  salut     |2 |

and not

| hi |<br>
| salut | 2 |