+3I have several FGDBs with same feature class and fields and I want to merge them into one FGDB, so I set Single Merged Feature Type at reader and Dynamic at writer. By setting Feature Read Mode as Metadata I can keep field alias, but I can't keep allow null values as NO, is there way to make it work?
Figs below show that field properties before and after running workspaces.
Before:
After:
Best answer by erik_jan
Writing to a FGDB, you can specify a template.
The writer will use that template to define the output.
So, using an empty FGDB as a template will allow you to pre-define what the output should look like.
Hope this helps.
+26Writing to a FGDB, you can specify a template.
The writer will use that template to define the output.
So, using an empty FGDB as a template will allow you to pre-define what the output should look like.
Hope this helps.
+3Writing to a FGDB, you can specify a template.
The writer will use that template to define the output.
So, using an empty FGDB as a template will allow you to pre-define what the output should look like.
Hope this helps.
I get it, I can copy one of FGDBs and delete all features in all feature class, then use this FGDB as template, I'll get an FGDB with original schema, wonderful solution! Thank you very much!
+26I get it, I can copy one of FGDBs and delete all features in all feature class, then use this FGDB as template, I'll get an FGDB with original schema, wonderful solution! Thank you very much!
Further, the tools in ArcMap for this are Create Feature Class/Create Table, which allow you to specify an existing Template FC/Table so effectively provide "blank" versions of then. Also an option is to use Truncate which can quickly delete all data from FCs and Tables and is far faster than Delete, but you do have to make sure you Compact the FGDB of using the Truncate method.
+3Writing to a FGDB, you can specify a template.
The writer will use that template to define the output.
So, using an empty FGDB as a template will allow you to pre-define what the output should look like.
Hope this helps.
Hi, I just found out that template didn't work when fanout expression was set, is this a bug or something else need to be set?
+3Further, the tools in ArcMap for this are Create Feature Class/Create Table, which allow you to specify an existing Template FC/Table so effectively provide "blank" versions of then. Also an option is to use Truncate which can quickly delete all data from FCs and Tables and is far faster than Delete, but you do have to make sure you Compact the FGDB of using the Truncate method.
What is Truncate method? I look it up and it seems that has something to do with Python which I'm not very familiar with. Can you show me an example?
+26What is Truncate method? I look it up and it seems that has something to do with Python which I'm not very familiar with. Can you show me an example?
@bobo
It is a standard ArcTool. Documentation here:
https://desktop.arcgis.com/en/arcmap/10.3/tools/data-management-toolbox/truncatetable.htm
