Exercise 3.3a Using Common Transformers
Data 3-1-1 case location details (XLS hosted on the web)
Overall Goal Add a transformer to clean up schema
Create a summary table
Demonstrates Common transformer procedures
Start Workspace C:\FMEData2019\Workspaces\IntroToDesktop\Ex3.3-Begin.fmw
End Workspace C:\FMEData2019\Workspaces\IntroToDesktop\Ex3.3-Complete.fmw

Your manager has some more requests for your workspace. City planners are undertaking strategic planning and want to know which local planning areas will need additional resources. They have sent you an Excel summary table of the 3-1-1 requests and have asked you to join it to a map of the local planning areas. They also want a copy of the original data with the edited schema. In this exercise, you will look for a transformer to join the summary table to mapping data.

Use the resources available (Transformer Gallery in Workbench, Transformer Gallery online, the FME Transformer Reference Guide, and Quick Add search) to find a transformer to join two streams of features. Then we'll go through the steps to add it.

FME Lizard says...
A join combines datasets based on a common attribute, or key.

OK, go for it! When you have found your solution, go to the next page to check your answer.

If you want some additional hints, click below:

Hint 1

The transformer is in the Filters and Joins category of the Transformer Gallery.

Hint 2

The transformer you are looking for has Joiner in the name.

Hint 3

While several transformers will work for this use-case, we want to carry out an SQL-style join of our features.

Hint 4

You might have found the FeatureMerger or the DatabaseJoiner; these transformers could be used here, but we are actually looking for one that works a bit better.

Additional Resources

If you have used the above resources and are still having trouble, try searching on the FME Knowledge Center.

results matching ""

    No results matching ""