Skip to main content
Solved

Dynamic Writer (File GDB)

  • February 3, 2021
  • 1 reply
  • 114 views

pflegpet
Contributor
Forum|alt.badge.img+8

Hi,

 

I have troubles setting up a dynamic writer. In my workbench I perform two different queries on a PostGreSQL/PostGIS database. I want to write the results of these queries in a FileGDB using a fanout that creates feature classes based on an attribute value. Furthermore I want to overwrite the entire GDB each time the workspace runs.

 

I setup a FeatureReader for each SQL query, connected the ouput+schema to a fileGDB writer using the dynamic writer option. It almost works as desired but the problem is that the different schemas are merged in the output, so each feature class now has all attributes from both SQL queries. Does anybody know if and how I can setup the writer to get the correct schemas. Thank you very much!

 

 

Best answer by pflegpet

I could find the solution myself: I had set the writer to "auto" before I changed to the "dynamic" setting. That's why all attributes were still present, even after switching to dynamic. I deleted the writer and created a new one with the dynamic setting from the beginning and now everything works as expected.

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

1 reply

pflegpet
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • Best Answer
  • February 3, 2021

I could find the solution myself: I had set the writer to "auto" before I changed to the "dynamic" setting. That's why all attributes were still present, even after switching to dynamic. I deleted the writer and created a new one with the dynamic setting from the beginning and now everything works as expected.


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