Reader is a single merged feature type reading 6 tables from an oracle database. Then using a feature type filter to export out the different tables, but the export contains the attributes for all the tables. How do I get the writer to just read the attributes for a particular feature type? Also when I update the feature type filter it removes all the tables and just adds one of the tables
Solved
How do i filter feature type attributes automatically?
Best answer by darkspatiallord
@jacq - if you have the feature reader you dont need the Reader at the front - they are doing the same thing. (unless you have feature read only reading the schema as suggested by Tia
If you want a Dynamic read and writer I'd suggest looking at the Dynamic workflows tutorials. Very Helpful
From what you are saying it looks as though you are hoping to do Dynamic Table and schema creation on the writer based on what you are reading in.
https://knowledge.safe.com/articles/1050/dynamic-workflow-tutorial-introduction.html
B
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.
+22- Safer
Hi @jacq, one way to set the attributes that you want to write for each table is to read in the tables from Oracle using the FeatureReader. You can read in the schema feature and use that to help define the tables on write.
We also have a great tutorial series about dynamic workflows, this article might be of use to you.
Hi @jacq, one way to set the attributes that you want to write for each table is to read in the tables from Oracle using the FeatureReader. You can read in the schema feature and use that to help define the tables on write.
We also have a great tutorial series about dynamic workflows, this article might be of use to you.
Hi @TiaAtSafe I am still having problems,
It keeps running....it wont stop lol
In this pic it is on its 3rd round, there should only be 32000 going to SP_PARCEL
What am i doing wrong?
+8- Supporter
- Best Answer
@jacq - if you have the feature reader you dont need the Reader at the front - they are doing the same thing. (unless you have feature read only reading the schema as suggested by Tia
If you want a Dynamic read and writer I'd suggest looking at the Dynamic workflows tutorials. Very Helpful
From what you are saying it looks as though you are hoping to do Dynamic Table and schema creation on the writer based on what you are reading in.
https://knowledge.safe.com/articles/1050/dynamic-workflow-tutorial-introduction.html
B
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.