Purpose & Objectives
This workspace demonstrates how to read data from a Microsoft Excel workbook containing employee information, filter for active employees using a transformer, and write the filtered data to a new worksheet in the same workbook.
Key Transformers
Tester: Used to filter the data based on conditional statements
Data Source(s) - Reader Feature Type
EmployeeRecord.xlsx Microsoft Excel - Employees worksheet
Data Output - Writer Feature Type
EmployeeRecord.xlsx Microsoft Excel - Newly created Active worksheet
Parameters:
Drop Existing Sheet set to Yes (the sheet will be dropped and recreated each time the workspace is run)
Customization
To customize this workspace, it is recommended to build the workspace from scratch as your dataset will have different attributes and schema (structure). Instructions to build this workspace: Getting Started with FME Form: Working with Table/Tabular Data.
Additional Resources
Microsoft Excel Reader/Writer
Tester
Visual Preview
For help with this workspace, please contact Safe Software Support and reference Getting Started with FME Form: Tabular
Would you like to know more? Click here to find out more details!