I am trying to create a new column from multiple columns in my dataset to extract the data point that I need. Lets say i have 2 columns Street and City. I want to create a new column Address, but in this column i will first see if the value in City column is present. If it is present, i will use that value, but in case it is blank, then i want to go to the Street column and pick the value from there. So basically City column takes priority over the Street column while creating the new Address column.
Is it possible to do this in ETL?
Thank you so much