Skip to main content
Question

Dynamic schema writing


boubcher
Contributor
Forum|alt.badge.img+11

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

todd_davis
Influencer
Forum|alt.badge.img+22
  • Influencer
  • July 1, 2020

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

 


Forum|alt.badge.img+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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings