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
Page 1 / 1
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.
Hi, this workspace will be re-used often. So i build it once but use it regulary.
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):