When using an SQLCreator and writing to a dynamic Excel-file for multiple queries I get the error the fme_feature_type does not exist. I've tried adding it with an attributeCreator with the value 'test' but the message keeps occuring.

Any thought

Question

FME version 19.1.2Warning message: Cannot define schema for 'test' as the feature does not contain schema information, and schema source is set to 'Schema from Schema Feature'. Please verify writer feature type configuration.Error message: XLSX Writer: No DEF line could be found for feature type 'test'. If you are using dynamic schemas, ensure that the fme_feature_type attribute exists on the incoming feature and corresponds to a valid feature type definitionWorkspace included below (I've tried 1 query now, but I'd like to add multiple using a conditional value for the sheet name)

ebygomm · Answer

You have it set to dynamic, which means FME is looking for schema information to determine which attributes to write into the excel sheet. If you only want to fanout the information on the sheet name (i.e. have the same attributes on each sheet) you don't need to use a dynamic writer

When using an SQLCreator and writing to a dynamic Excel-file for multiple queries I get the error the fme_feature_type does not exist. I've tried adding it with an attributeCreator with the value 'test' but the message keeps occuring. Any thought

2 replies

Community Stats

Community Stats

Sign up

An FME Account is required to contribute

Login to the community

An FME Account is required to contribute