I want to update the target table with some values from another table.I tried using update transformation and table-loader,it didn't work. My target table has a column note_type with values 'GRAD' and 'note'.I want to update the column reason_code for only 'NOTE' from another worktable in sas di.Could anyone let me know please.
... View more