Skip to main content
Question

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


ares
Contributor
Forum|alt.badge.img+2
  • Contributor
  • 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

2 replies

ebygomm
Influencer
Forum|alt.badge.img+38
  • Influencer
  • April 19, 2023

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


ares
Contributor
Forum|alt.badge.img+2
  • Author
  • Contributor
  • April 19, 2023

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.


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