Skip to main content
Solved

How do i filter feature type attributes automatically?


Forum|alt.badge.img

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

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

View original
Did this help you find an answer to your question?

4 replies

fmelizard
Safer
Forum|alt.badge.img+19
  • Safer
  • October 12, 2017

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.


Forum|alt.badge.img
  • Author
  • October 12, 2017

Hi @TiaAtSafe That's much better, thankyou very much :)


Forum|alt.badge.img
  • Author
  • October 12, 2017
fmelizard wrote:

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?


darkspatiallord
Forum|alt.badge.img+6

@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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings