How to handdle chars '<' and '>' in XML Output Stage

[YankeeYank]

Hello DS Experts,

I am trying to generate an XML using XML output Stage. Job design is

DataSet ------> Transformer ---------> XML Output

I have used following code in derivation of a column in Transformer

Code: Select all

'<NUMBER><NUM_TYPE>PAN</NUM_TYPE><NUM_VALUE>':NullToEmpty(DSLink2.PAN):'</NUM_VALUE>' 

I have got following output in XML

<NUMBER><NUM_TYPE>PAN</NUM_TYPE><NUM_VALUE>1234567890</NUM_VALUE>

I have even tried escaping as

Code: Select all

'\<NUMBER\>\<NUM_TYPE\>PAN\</NUM_TYPE\>\<NUM_VALUE\>':NullToEmpty(DSLink2.PAN):'\</NUM_VALUE\>

and got output as

\<NUMBER\>\<NUM_TYPE\>PAN\</NUM_TYPE\>\<NUM_VALUE\>1234567890\<

Please suggest is there any way to escape chars '<' and '>' in XML output Stage.

Best Regards

Rahul

[ray.wurlod]

Mark the output as XML. No conversion will occur. Search DSXchange for details of the technique.

[YankeeYank]

Hi Ray,

Thanks a lot . Issue got resolved using Craig solution

Set the 'Data Element' to XML for the chunk data so it knows it is already XML and doesn't make that conversion.

Regards

Rahul

[ray.wurlod]

That's what I meant with "mark as XML". Too used to it, I guess.