|Exercise 3.3a||Using Common Transformers|
|Data||3-1-1 case location details (XLS hosted on FTP)|
|Overall Goal||Add a transformer to clean up schema
Create a summary table
|Demonstrates||Common transformer procedures|
Your manager has some more requests for your workspace. The department wants to be able to provide a summary of the number of cases by department, by Local Planning Area, in addition to the original data with an edited schema. This summary table will help the city assess demand for different services in different areas of the city. In this exercise, we will use a transformer to generate a summary table.
Before we go through the steps for doing so, try to find which transformer to use!
Use the resources available (Transformer Gallery in Workbench, Transformer Gallery online, the FME Transformer Reference Guide, and Quick Add search) to find such a transformer. Then we'll go through the steps to add it.
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:
The transformer you are looking for has Calculator in the name.
To create a summary table, you need to calculate the sum of cases. The sum is a statistic of your attributes.
If you have used the above resources and are still having trouble, try looking on the FME Knowledge Center.