Hi,
I want to keep a number of attributes of a table. I have the attributes to be preserved in an Excel file. Can I keep the correct attributes using the Excel file?
Greatings
Question
Keek attributes which are listed in a file
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.
+62
Not sure if I understand correctly. Do you want to do this once? Or in a dynamic translation?
We can't import attribute names in the AttributeKeeper. But you can import them in the AttributeExposer. I always read data Generic, and only expose the fields I need.
+5- Contributor
Hi, this workspace will be re-used often. So i build it once but use it regulary.
+12- Contributor
My understanding is that you have certain attributes in excel file which you want to retain during translation.
If the attributes are less in number then I suggest to use AttributeKeeper with User Parameter option. With this option, FME asks you the names of the attributes which you need to select before translation (instead of excel file)...
@fme_hans You can use the dynamic schema on the writer to control which attributes are written. You can define the schema using the attribute{} list. Your workspace will look something like this:
When you add your writer, select Table Definition: Dynamic (Advanced)
I've attached an example (FME 2020.2):