Hello,
what are the options for converting Excel data to XML, please? Can you provide me with multiple options (easier/more complex)? Is it possible to show me a graphical representation or even send a file directly?
The problem may also occur with the XML file format, but I would address it by using an XSD file.
Thank you very much in advance for your help.
This is an incredibly open ended question. Without examples of the input data there's not really any examples that can be provided.
There's also the question of what does the output xml need to look like? Is there a specific schema it needs to conform to? Is the data going to be at a single level or are there sub levels that form a 1:N relationship (arrays/lists).
If the data is 100% flat, then you can export the xml directly from excel: https://support.microsoft.com/en-gb/office/export-xml-data-0b21f51b-56d6-48f0-83d9-a89637cd4360
This will at least give you a starting pont of how you need to do it in FME