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
+54
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.
+11- 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):
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.