SQLQuery query = new SQLQuery();
query.setResourceID(resource);
query.addExpression("SELECT * FROM replace_values");
CalculateMean mean = new CalculateMean();
mean.connectDataInput(query.getDataOutput());
ConditionalSplit split = new ConditionalSplit();
split.addCondition("A>=3.0 AND A<3.5 OR A IS NULL");
split.connectDataInput(query.getDataOutput());
ReplaceWithValue replace = new ReplaceWithValue();
replace.connectValuesInput(mean.getDataOutput());
replace.connectDataInput(split.getTrueOutput());
replace.addColumns(new int[]{0});
TupleUnionAll union = new TupleUnionAll();
union.setNumberOfInputs(2);
union.connectDataInput(0, split.getFalseOutput());
union.connectDataInput(1, replace.getDataOutput());
TupleToWebRowSetCharArrays webrowset = new TupleToWebRowSetCharArrays();
webrowset.connectDataInput(union.getDataOutput());
DeliverToRequestStatus deliver = new DeliverToRequestStatus();
deliver.connectInput(webrowset.getResultOutput());