How to create a xml output with dynamic schema

[Meghana2]

Hi Everyone,

I have a requirement to create a XML file from the query result.

Here the query schema is dynamic.

We have dynamic data type facility for any other output file component like tFileOutPutDelimited and tFileOutputExcel components but looks like tFileOutputXml doesn't have.

How could I achieve this.

Thanks in advance

[Anonymous]

Hi

As prompted by the component, tFileOutputXML does not support dynamic schema. So, you can't create a XML file with dynamic schema.

Regards

Shong

[Meghana2]

Yes, But do we have any other way to create XML file with dynamic schema.

One way I could think is to create csv file and then convert to XML file.

Thanks