Skip to main content
  • EN

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!

 

 

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.

Reply


Community Stats

30,185
Posts
114,569
Replies
37,847
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.