+5I have a workspace where I gather the data from the web and upload on data base
whenever data available my script run and load the data on the database with truncate.
now the issue is on the source table remove the data until new data is not available
so when I run the script the feature reader shows me nothing. so how can I truncate as well until new data is not available?
as you can see Advisory Wind don't have records from source so if there is record i need to truncate my table 
@asadamjad There is a NoFeaturesTester custom transformer on FME HUB that you can use to test for when not features are received. Then you can do something like run a SQL script using SQLExecutor to truncate your tables.
+5This transformation is okay, but I am not looking at this.
When inserted, hit the feature reader and know the feature is empty or has a record. 
+58Something like this?
No data? --> Truncate the table in the SQLExecuter
Data? --> Truncate the table in the FeatureWriter
