Running multiple SQL queries from excel file

in broad terms each row from Excel should go into a SQLExecutor that runs that query and creates features from the result. You can then write that out to whatever format you like.

Are the 50 result sets expected to have different columns? If so, you’ll need to make sure to also read Schema features and to retain the original attributes so you can tell the sets apart.

Maybe you can modify the best answer to this question to your needs.

Hi ​@tthach830 ,

SQLExecutor creates schema feature(s), but “fme_feature_type_name” attribute in schema features and “fme_feature_type” attribute in data features both stores text string "SQLExecutor" by default.

If you would like to make destination csv file name the value of "Name_SQL_Query" with the dynamic schema mechanism, you will have to modify those attriute value appropriately.

A possible way is:

• SQLExecutor : Set "Keep Initiator Attributes if Conflict" to the Combine Attributes parameter to propagate "Name_SQL_Query" attribute to output features, set "Schema and Data Features" to Features to Read parameter to read both schema features and data features.
• Schema features from <Schema> port : Expose "Name_SQL_Query" attribute with AttributeExposer and then rename it to "fme_feature_type_name".
• Data features from Result port : Rename "Name_SQL_Query" to "fme_feature_type".
• In the CSV writer feature type, set general parameters like below. 
  • CSV File Name : fme_feature_type
  • Dynamic Schema Definition : <check>
  • Schema Sources : "Schema From Schema Feature"
  • Schema Definition Name : <Default from CSV File name above>

See also the screenshot below.