Skip to Content
0
Former Member
Aug 11, 2016 at 01:38 PM

Proxy to SFTP CSV File : Empty values handling

149 Views

Hello,

I have a proxy to SFTP CSV file scenario and i want to apply content conversion using StructXML2Plain module.

My structure is as follow :

<Struct>

<SubStruct>

<Col1>Value1</Col1>

<Col2>Value2</Col2>

<Col3>Value3</Col3>

</SubStruct>

<SubStruct>

<Col1>Value4</Col1>

<Col2>Value5</Col2>

<Col3>Value6</Col3>

</SubStruct>

</Struct>

When the proxy generates a xml payload without <Col2> in <SubStruct> i'll get this result :

Col1 ;Col2 ;Col3

Value1;Value3

Value4;Value6

I want to get blank value instead of having nothing :

Col1 ;Col2 ;Col3

Value1; ;Value3

Value4; ;Value6

How can i do this in StructXML2Plain module ?

Thanks

Sako