I have an excel with the definition of the Schema
Fme-feature type ( table to create)
name ( the attribute to creat )
this is only sample data, I used the featured reader to read the empty schema use the list explorer to get the data attached in the excel, how could we create the same schema into the DB
Note ( the source has no features )
Here it is. Just needs to be built into a list to create and setup in the writer.
More details: https://knowledge.safe.com/articles/1051/index.html
You can also avoid writing the feature into the table with fme_schema_handling = schema only, but have avoided that in this example due to another issue.
Cheers,
Todd
@boubcher the Schema (from Table) Reader will turn your spreadsheet into a schema feature that you can sed (as the first feature) to your database writer.