The Schema (From Table) reader produces FME features with schema information extracted from specially formulated tabular data.
This reader is most useful when combined with transformers that can use the schema information to manipulate the output. It is not intended to be used as part of a true translation.
The Schema (From Table) reader acts as a wrapper for the true reader which will be used to retrieve the schema from a specially formulated table in a given dataset. The table below gives an example of information that can be used to generate schema information:
|Bus Stops||Stop Name||fme_varchar(20)||fme_point||2|
|City Parks||Park Name||fme_varchar(20)||fme_polygon||2|
|Park Short Name||fme_varchar(10)||3|
The Schema (From Table) reader takes a file or multiple files, folder, URL, or database name as the input dataset. If the format that is ultimately targeted requires an input folder, the Schema (From Table) reader will turn the input filename into a folder by removing the file name part of the path.
Because the format it will read from can be, and is by default, published, workspace authors who want to set up specific data-flows for a particular format can use the ParameterFetcher transformer to retrieve the name of the format that actually is being read to, and then potentially route features to other transformers using this value.
FME uses Dynamic Schema functionality, so it can determine the writer schema at run-time. This allows you to decouple your schema definitions from the workspace for greater flexibility and reusability, and less maintenance.
Refer to the dynamic schema examples in the Dynamic Workflow Tutorial.