table to xml
Hello, I have to generate an XML with the following structure:
root>
<products>
<product>
<reference>PRODUCT 1</reference>
<reference>PRODUCT 2</reference>
<reference>PRODUCT 3</reference>
</product>
</products>
</root>Where the PRODUCT 1, 2, etc. need to be replaced by the values from a table like this one:
I have been exploring the “Column to XML” and “String to XML” nodes, but I cannot find a way to achieve what I need. Does anyone have any ideas on how I can do this?
thanks!