Question

Dynamic schema writing


Badge +10

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 )

 

 

 


2 replies

Userlevel 1
Badge +12

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

 

Badge +2

@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.

Reply