XML with key as static Value in tfileoutputMSXML

[Anonymous]

Hi 

I've one input file like below

ID,MID,NAME
1,0,A

And want to convert it into xml using tfileoutputMSxml. Output should be like below

<Employees>
<Employee key="ID">1</Employee>
<Employee key="MID">0</Employee>
<Employee key="NAME">A</Employee>
</Employees>

Am not able to set "<Employee key="ID">1</Employee>" kind of tags in component. Can anyone help how to set this in component ..?

[Anonymous]

Hi @rhall, thanks for sharing your logic. Yes I did solve my problem using java. I did some operation that applies on xml once its generated.

Your logic also sounds interesting.  Will try also as well and will update you how it goes.

Thanks...!