Hi all,
I would like to: list feature classes/layers from a file geodatabase. Sort. Keep first N tables and drop the rest.
All is good till dropping the tables . So my question is how to drop a list of tables in a File Geodatabase
I looked at SQLExecutor and there is no option for Esri File geodatase.
In the geodatabase writers you can only "Drop and Create" tables.
This example seems promissing, except I would need to update the User Private Parameter with an sql of tables to drop, and it does not seem to be working in that direction : workspace variable => Published Private Parameter. Or does it?
Just to mention that in this example, if I hardcode the Published Private parameter with list of tables to drop it works
"FME_SQL_DELIMITER ; DROP TABLE first_table; DROP TABLE second_table;"
All suggestion are welcome and thanks in advance
Inside the featurereader parameters section, you'll see the sql to run after write. might need to play with the sql a bit, but it would look something like this. it uses the attribute value to reference the tables needing to be deleted. 
--