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