span8
span4
span8
span4
When starting a schema mapping project it may be helpful to load all the feature type data into lookup tables for use with theSchemaMapper transformer.This creates a great starting point and eliminates the need to manually copy data by hand.Using this technique should dramatically speed up the schema mapping setup process,especially when there are multiple input files being mapped.
This article displays two separate methods to build a lookup table.Each lookup table is separated by the type of schema mapping being performed: Attribute Mapping,Feature Type Mapping,and Filtering.
This article is part of theSchemaMapper Transformer: Tutorial
lookuptablegenerator.fmwt: This workspace generates two separate lookup tables,one for Attribute mapping and another for Feature Type mapping.
filtertablegenerator.fmwt: This workspace generates a lookup table which contains all the attribute names and their unique values for each Feature Type.
In this example,a series of shapefiles are going to have their attributes mapped using the SchemaMapper.They are read into the workspace using the merge filter.
TheSchema (Any Format)reader pulls out all the attribute names from the files and then writes them to the lookup table.Since the reader pulls the attributes into a list,a ListExploder transformer is used to grab each attribute name.
Lookup Table Generator Workspace:
At the same time,a separate table is generated listing each input Feature Type's name using the incomingfme_feature_type
name attribute.
Example Feature Type Table:
Example Attribute Table:
The resulting lookup tables both contain a blank column enabling a user to add their own schema mapping rules.Once completed,the lookup table can be processed by SchemaMapper transformer.
Example 2: Filter Lookup Table
This type of lookup table is used with the SchemaMapper's Filter Action.In order to set up a filter,the SchemaMapper must know attribute names and their unique values for the Feature Type.This workspaces produces a lookup table that contains unique values for each attribute contained by the input feature type.
Filter Generator Workspace:
In this example,a shapefile of water main data is going to be used to generate the filter lookup table.
First,the dataset is read into the workspace using a Generic reader.An AttributeRemover is used to strip out any unnecessary data (for example,theOBJECTID
) and then each attribute is exploded and duplicates are removed.Finally,the data is sorted and written to the lookup table.
Example Filter Lookup Table:
In the lookup table output,extra blank columns (Source,Destination) are added,enabling a user to add their own schema mapping rules.Once completed,the lookup table can be processed by SchemaMapper transformer
Dynamic 亚搏在线Workflows: Advanced Example - Modifying the Schema Feature
Configuring the SchemaMapper Transformer
Dynamic 亚搏在线Workflow Tutorial: Advanced Technique - Using the SchemaMapper
SchemaMapper: Advanced Schema Mapping
SchemaMapper: Attribute Mapping
Tutorial: SchemaMapper Transformer
SchemaMapper: Feature Type Mapping
© 2019 亚搏在线Safe Software Inc |Legal