Hello, just started FME a few days ago. Have an Excel file with 3 columns containing geometry in WKT format. How do I translate into readable geometry? Example: POINT (2648.81837074121 433.2500) Thanks
+12- Contributor
Best answer by nielsgerrits
Not sure what you mean with "readable geometry", but you can use the GeometryReplacer to create a geometry from the attribute. Set it to OGC Well Known Text.
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.
+64- Best Answer
Not sure what you mean with "readable geometry", but you can use the GeometryReplacer to create a geometry from the attribute. Set it to OGC Well Known Text.
+12- Contributor
Hi @nielsgerrits ,
Appreciate the reply. It worked! Would never have picked that transformer, so there must be some idiosyncrasies to learn.
Just to clarify about "readable geometry": When inspecting the data, it looked exactly like the .txt file version, which was able to display (read) geometry no problem. With the Excel file, I got "There is no geometry in this view". Not sure why.
At any rate, thanks for the help and looking forward to asking more advanced questions.