I am looking for inputs on how to dynamically filter columns that has null values and map that to tMSSqlOutput.

Here is the scenario i am running into.

We have to set default values for may fields that are inserted into sql server db, problem is inserting records using tMSSqlOutput don't default column since null is  passed and if column values are passed(with null) they don't get defaulted in database.

So question is how can i filter out null columns before i connect that to tMSSqlOutput? so basically right between tMap and tMSSqlOutput i want to filter out columns that have null so they don't  appear in insert statement that is generated by tMSSqlOutput  component.

We are trying to avoid using default option in schema for each of the columns as we will have to maintain defaults at two places, one in talend and another in database.

I am using TIS 4.2.3

Job looks like
tFileInputExcel
         |
         |
     tMap
         |
         |
tMSSqlOutput