DW object field transformation

Hi All,

I am working on a table fields in an object in DW. The table contains data that are dynamic in a way, where one field is related on the other. Let say that this table contain field for a Staff ID and Manager ID for void transactions, whereas i need to show the manager ID if there is data in the column while if there is none, then the Staff ID data will be shown.

Any idea on how i can write this condition on SQL custom field transformation?




Please sign in to leave a comment.