I have a single table, TABLE1. I have a field named STE. I would like to select the values of STE that are NOT NULL, then add the selected values in STE to the ADDR field in same table.
What is the most suitable transformer(s) to go about doing this?