Pulling Content from a Node (XML files)
I want to be able to pull one metadata item from hundreds of XML files. Is there a function that will allow CloverETL to 'look' in a folder where the xml files reside and extract the one piece of data I need from all of the files?
I want to be able to pull one metadata item from hundreds of XML files. Is there a function that will allow CloverETL to 'look' in a folder where the xml files reside and extract the one piece of data I need from all of the files?
-
Hi leefate
If I understand your question correctly, you want to extract a particular Element from multiple XML Files. If that's the case, you can accomplish this using the XMLExtract component and use a wild card in the URL. Assuming that all the XML files are the same structure, you will need to create the metadata upfront using the mapping field in the XMLExtract which will automatically create the XSD.
I have taken the liberty of building a project with an example of your use case.
XMLExample.zip
Please sign in to leave a comment.
Comments 1