Hei,
I have Data Interoperability ETL Spatial Tool which is reading multiple gml-files from a directory processing them together (merge, dissolve, remove duplicates etc) and writing features to the SDE Geodatabase. Need to use truncate for table before writing.
In DI I have Reader Source like: D.\temp\input\*.gml.
When running this as DI Spatial ETL Tool it works fine. It read all the files => process them together =write to SDE.
Now I need to make ArcGIS Service from this DI tool. It needs Model. I can place DI ETL Spatial Tool to Model without problems. But how to make model process all source gml-files together? I have tested everything without success. Trying to place Folder-parameter and File-Iteration or List of files. But Model always execute one gml-file at a time before reading next one and the result is output table containing features only from the last file.
Help needed. I am not so familiar with ModelBuilder- All hints and tips are welcome.
With FME and FME Server this is so easy. Data Interoperability drives me crazy.
Solved! Go to Solution.
Found the solution. Easy. Basic ModelBuilder stuff.
In the model I just need to use 'Collect Values' tool before 'ETL Spatial Tool'.
As it is stated in help:
”The Collect Values tool is designed to collect output values of an iterator or to convert a list of multivalues into a single input. The output of Collect Values can be used as input to tools such as Merge, Append, Mosaic, and Cell
Statistics.”
Found the solution. Easy. Basic ModelBuilder stuff.
In the model I just need to use 'Collect Values' tool before 'ETL Spatial Tool'.
As it is stated in help:
”The Collect Values tool is designed to collect output values of an iterator or to convert a list of multivalues into a single input. The output of Collect Values can be used as input to tools such as Merge, Append, Mosaic, and Cell
Statistics.”