I am new to FME, and I am trying to extract data of specific lines of the XML, but once I import the XML, I am unable to find these lines referenced anywhere. Is there a transformer that I could use that I could define the required line (by attribute contained in that line if possible) that would then extract the data so I could consume it
Solved
Extracting specific lines of data from XML
Best answer by erik_jan
The XML reader allows you to specify the element you want to see as feature types in your FME workspace.
You can find that setting here:
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+9- Safer
Hi @gavin_082, thanks for your question!
For a more detailed discussion of your technical issue, would you mind posting a sample of your data and your workspace to this posting?
I'm not an XML expert, but I wonder if an XQuery function might solve your problem. Take a look at this article and this article for some more information. XQueries allow you to extract data from within an XML document in a similar way to an SQL statement. They can be useful if you know where in your XML document the desired data is (ie between which tags).
Hope this helps!
Thanks,
Nathan
+26- Contributor
- Best Answer
The XML reader allows you to specify the element you want to see as feature types in your FME workspace.
You can find that setting here:
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.