Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • 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
  • FME version 19.1.2
  • Warning 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 definition
  • Workspace included below (I've tried 1 query now, but I'd like to add multiple using a conditional value for the sheet name)

image

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

I would like to write 6 different queries with 6 different sets of attributes to 6 different sheets in one Excel-file. For the sheet name of each query I'd like to use a custom attribute which attribute name -so I thought- should contain the name of the sheet. This custom attribute should then be added to the parameter 'Sheet Name' in the Feature Writer. But I am still new to FME, so I don't know exactly how this should be done.

Reply


Community Stats

30,122
Posts
114,333
Replies
37,751
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.